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/
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.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.