Follow this topic

Marwa Almaqtari

Last answered:

01 Dec 2021

Posted on:

18 Nov 2021

0

match & index vs vlookup

in Advanced Microsoft Excel / Advanced Excel Functions Index, Match, Match

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)

Martin Ganchev

Instructor

Posted on:

01 Dec 2021

0

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

Submit an answer

related questions

0

10

exercise - index match march

0

8

Resolved: What diff between (index, Match & Match) and (indext, Match) ?

0

8

index with match vs offset with match

0

6

Specifying the array in Index formula

1

6

Resolved: How do I use "index match match" when I have several arrays?

0

6

Resolved: Index Match Match Issue

0

6

Index match, I have problems in copying down the fomular to give me the results I want.

0

6

Why doesn't the Index+Match example in this lesson need a column number for the Index function?