match & index vs vlookup
I need to ask what is the difference between match & index and vlookup , do they have the same usage and functionality?
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