what is the difference between index+match and vlookup function?

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

Follow this topic

Marwa Almaqtari

Last answered:

01 Dec 2021

Posted on:

18 Nov 2021

Question about match and index functions

in Advanced Microsoft Excel / Advanced Excel Functions Index; Match; Index & Match

1 answers ( 0 marked as helpful)

Martin Ganchev

Instructor

Posted on:

01 Dec 2021

Question about match and index functions

Submit an answer

related questions