3 Ways to Copy Another Cell If Two Cells Match in Excel

If you are looking for how to copy values to another cell if two different cells match in Excel, then you’ve come to the right place. There are several ways to copy values to a different cell if two of the cells match in Excel. And in this article, we’ll try to talk about the 3 quickest ways to copy values to a different cell if two of the cells match in Excel. Here is an example of our result.

excel if two cells match then copy another cell


📁 Download Excel File

Download this practice book.


Learn to Copy Another Cell If Two Cells Match in Excel Easily with IF Function

Here is our dataset. In this sample dataset, we have two categories of fruit listed along with their price per 100 kg. Some of the names of the product items may be the same. Now, all you need is to copy the prices of the items that are already in your worksheet into another cell. You can read the whole article if you are having this problem right now as you are going to learn 3 easy ways to copy the same value from one cell to another if two of the cells in Excel are the same.

Dataset

We’re going to copy the prices of products that are the same as others. There is another column called “Matched Price“. This is where you will copy the prices of the items that are the same. We only need IF function to do all of these things.  IF function enables you to compare a value to what you anticipate logically.

⬇️⬇️ STEPS ⬇️⬇️

  • At first, we select cell E6. Then we put the formula below.
=IF(B6=C6,D6,””)

Putting Formula

🔨  Formula Breakdown

👉  IF Function will compare the column B and C values.

👉  D6 means if the match is found, the value of the D column will be returned.

👉  “” returns a blank value if no match is found.

  • Then we press Enter. The final result will be like this.

excel if two cells match then copy another cell


How to Copy to Another Cell If Cell Contains Text in Excel

Filter Command Feature is a powerful tool for calculating, summarizing, and analyzing data that lets you see comparisons, various patterns, and some trends in the data. Now I’ll demonstrate how to use excel if a cell contains text then copy to another cell using Filter Command Tool.

⬇️⬇️ STEPS ⬇️⬇️

  • Firstly, we select our dataset.
  • Then we select Data tab and select Filter.

Custom Filter.

  • Now we go to the Product Code header from the drop-down box and then Number Filters and then Custom Filter.

Using Filter

  • Now we put contains and Asterisk(*) sign in the boxes and press on OK.

Custom Autofiller

  • The result will be like this. Now we copy the whole dataset by holding Ctrl and A together, then holding Ctrl and C together.

excel if two cells match then copy another cell using Filter

  • In a new worksheet where the headers are already there.

New Worksheet

  • We select cell B6 and press Ctrl and V Here is our final result.

excel if two cells match then copy another cell to new worksheet


📄  Important Notes

🖊️  In Excel, the ribbon is used to access various commands. You can change a lot of things in the options dialogue window, like the ribbon, formulas, proofing, saving, and so on. So the appearance of worksheets on your device could be different from ours.

🖊️  A practice workbook is given so that you can practice yourself.

🖊️  All these exercises and tutorials are done on Microsoft Office 365. Some functions may be unavailable in previous versions.

🖊️  At the side of each Excel worksheet file, there is space where they can practice.


📝  Takeaways from This Article

📌 Readers will be able to copy values to another cell if two of the cells match in Excel in various methods.

📌  The readers can implement VLOOKUP Function to copy values to a different cell for the same case.

📌  They can also use INDEX and MATCH Functions to copy values to a different cell after matching two cells.

📌  Finally, the readers can utilize IF Function to do the same.


Conclusion

That concludes today’s session. These are the methods in Excel if two of the cells match, then how to copy to another cell. We are hopeful that this article will be extremely beneficial to you. Don’t forget to leave your thoughts and questions in the comments section and explore our website, ExcelDen.com, the best Excel solutions provider.

 

(Visited 42 times, 1 visits today)
Tanzim

Tanzim

My name's Tanzim. My articles are meant to help you learn more about how Microsoft Excel works and how to use its different features. I enjoy gaming and hope that some of my knowledge will help me provide you with some interesting articles despite some tiresome technical terms.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo