Follow this topic

Marwa Almaqtari

Last answered:

01 Dec 2021

Posted on:

18 Nov 2021

0

Question about match and index functions

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

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

1 answers ( 0 marked as helpful)

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

I have Mac Book and find and replace doesn't have the same options as in course

0

8

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

0

8

index with match vs offset with match

0

6

Conditioal formatting question

0

6

Specifying the array in Index formula

0

6

Resolved: Advanced excel functions- indirect function

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.

1

6

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

Димитър Димитров

0

6

Why you chose 0.1 and 0 for the number values?

0

6

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