Forum Discussion
Solved
How to Return Column Data Based on Matching Row Data in First and Second Worksheets
Hi All, I am not really sure how to explain what I want to accomplish, but I believe what I am looking to do is possible with INDEX and MATCH. Basically, I have a column of data on one worksheet ...
Maybe just try using a vlookup:
Here is some additional info on how the function works:
https://www.excelcampus.com/functions/excel-vlookup-explained/
What would be the difference between using a VLOOKUP function and a combined INDEX and MATCH function?
Off the top of my head:
1. Index / Match formulas can be more efficient in large data files. For the average file the calculation time will be negligible.
2. Index / Match is superior to vlookup in that it can look at data left to right (like vlookup) but also right to left.
3. Index / Match syntax is harder to remember.
1. Index / Match formulas can be more efficient in large data files. For the average file the calculation time will be negligible.
2. Index / Match is superior to vlookup in that it can look at data left to right (like vlookup) but also right to left.
3. Index / Match syntax is harder to remember.
I went ahead and read through how to perform the INDEX MATCH function and used that on my data set because it is fairly large and complex.
It worked really well. I am curious what else I'll be able to do with it.
Thanks for the help.