Question about match and index functions
what is the difference between index+match and vlookup function?
1 answers ( 0 marked as helpful)
Hi Marwa!
Thanks for reaching out.
The main difference is that VLOOKUP() requires a static column reference, while INDEX+MATCH requires a dynamic column reference. You can explore that difference by watching the relevant lectures from our course:
https://learn.365datascience.com/courses/advanced-microsoft-excel/advanced-excel-functions-index-match-index-match/
https://learn.365datascience.com/courses/advanced-microsoft-excel/advanced-excel-functions-indirect-vlookup-indirect/
Hope this helps.
Best,
Martin