If Value Exists in Column Then Copy Another Cell in Excel (3 Ways)

You have come to the right place if you are looking for the answer or some unique tips to copy another cell if a value exists in a column in Excel. There are 3 ways to copy another cell if a value exists in a column in Excel. This article will walk you through each and every step with appropriate examples. As a result, you can use them easily for your purpose. Let’s move on to the article’s main discussion.

Download Practice Workbook

You can download the practice workbook from here:

3 Ways to Copy Another Cell in Excel If Value Exists in Column

In this section, I will show you the quick and easy steps to copy another cell if a value exists in a column in Excel on the Windows operating system. This article contains detailed explanations with clear illustrations for everything. I have used the Microsoft 365 version here. However, you may use any other version depending on your availability. Please leave a comment if any part of this article does not work in your version.

Here, I have a dataset of Code numbers of products, product names, colors, sizes, and prices. I want to check a code whether exists in the column and if exists then I will copy the price of that product.

1. Using Filter Command

For this, I will use the Excel Filter option to search for the value.

📌 Steps:

• First, select the Column Header of Code column.
• Then, go to the Home tab and select the Filter Option under the Sort & Filter

• As a result, there will create a filter icon on each header of the data table.
• Then, click on the filter arrow of the Code column and there will open a context menu.
• Under the Text Filters menu, select only the cell that you want to get.
• Alternatively, for large data, you can search that item in the Search box under the Text Filter menu.

• As a result, you will see that row only that is visible and other rows become hidden.
• Now, you can use the Ctrl+C shortcut to copy other cell values of the row.

Read More: How to Copy Rows in Excel with Filter (6 Fast Methods)

2. Using FILTER Function

Alternatively, you can use the FILTER function to do the same thing. Follow the steps below.

📌 Steps:

• First, insert the value for which the function will search in cell I5.

• Then, insert the following formula in cell H6:

Read More: How to Copy a Cell in Excel Using Formula(7 Methods)

Similar Readings

• How to Copy and Paste Conditional Formatting in Excel
• Copy Same Date in Excel (6 Simple Methods)
• How to Copy Every Nth Row in Excel (4 Easy Methods)
• Exchange (Copy, Import, Export) Data Between Excel and Access
• How to Use Paste Special Command in Excel (5 Suitable Ways)

3. Using VBA Code

Alternatively, you can use a VBA code to do the same thing. Follow the steps below for this:

📌 Steps:

• For this, first, go to the top ribbon and press on the Developer, then press on the Visual Basic option from the menu.
• You can use ALT + F11 to open the “Microsoft Visual Basic for Applications” window if you don’t have the Developer tab added.

• Now, a window named “Microsoft Visual Basic for Applications” will appear. Here from the top menu bar, press on the “Insert” And a menu will appear. From them, select the “Module’” option.

• Now, a new “Module” window will appear. And Paste this VBA code into the box.

Sub CopyBudgetRecords()
Dim copyrng As Range
Dim cell As Range
Dim PasteRng As Range
Set copyrng = Sheet1.Range("B5:B20")
For Each cell In copyrng
Set PasteRng = Sheet4.Range("A5")
If cell = "C_O_M" Then Range(cell.End(xlToLeft), cell.End(xlToRight)).Copy PasteRng
Next cell
End Sub

Sub CopyBudgetRecords()

Dim copyrng As Range 
Dim cell As Range 
Dim PasteRng As Range

Set copyrng = Sheet1.Range("B5:B20")   

For Each cell In copyrng
Set PasteRng = Sheet4.Range("A5")

If cell = "C_O_M" Then Range(cell.End(xlToLeft), cell.End(xlToRight)).Copy PasteRng 

Next cell
End Sub

• To run the code go to the top menu, press on the Run option, and here will open some other options and select the Run Sub/UserForm also you can simply press F5 to run the code.

• As a result, you will see the cell range B5:F5 is filled with values that are the copy of the selected dataset.

Read More: Excel VBA: Copy Cell Value and Paste to Another Cell

How to Lookup Value in a Column and Return Value of Another Column in Excel

The business world deals with massive datasets. Microsoft Excel has made their job easier by providing various formulas for easily maintaining datasets. However, the most common thing in dataset maintenance is looking up values in a column and getting the return of another column of related data. I will show you how you can do this:

📌 Steps:

• Here, I have a dataset of Code numbers of products, product names, colors, sizes, and prices.
• Now, I want to use a lookup value of the product code inserted in cell I5 and search for this cell in the dataset and get the return of the price.
• For this, I have used the following formula in cell I6:

• Thus, you can easily get the return from another column for matching a cell using the VLOOKUP function.

Read More: How to Copy and Paste Multiple Cells in Excel (8 Quick Methods)

Conclusion

In this article, you have found how to copy another cell if a value exists in a column in Excel. I hope you found this article helpful. You can visit our website, ExcelDemy, to get more Excel-related content. Please leave comments, suggestions, or queries if you have any in the comment section below.

Related Articles

• How to Copy Paste Vertical to Horizontal in Excel (2 Easy Ways)
• Copy Chart Format in Excel (3 Easy Ways)
• How to Copy from PDF to Excel and Keep Columns
• Copy Conditional Formatting Color to Another Cell in Excel
• How to Copy Above Cell in Excel (3 Easy Ways)
• [Fixed!]: Microsoft Excel Cannot Paste the Data as Picture
• How to Copy PDF File Names into Excel (9 Efficient Methods)