Last answered:

28 Dec 2023

Posted on:

28 Nov 2023

0

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

I didn't understand when I used (index, match, and match) instead of match and index.


4 answers ( 2 marked as helpful)
Instructor
Posted on:

29 Nov 2023

0

Hey Daniel,

Good to hear from you! Could you elaborate, please? Do you mean why we use INDEX, MATCH, MATCH and not simply INDEX, MATCH? Thanks!

Best,

Ned

Posted on:

06 Dec 2023

1

Exactly, I have the same Question!

why do we use INDEX, MATCH, MATCH, and not simply INDEX, MATCH? 

Instructor
Posted on:

28 Dec 2023

1

Hi everyone!

I hope you don't mind if I join the conversation.

@Raza: When we use INDEX(... MATCH()), we use row references in the MATCH() function. With INDEX(..., MATCH(), MATCH()), we can use row and column references.

Please feel free to rewatch the following course lectures, containing relevant examples, for more information:

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-index-match-match/

Hope this helps.
Kind regards,
Martin 

Posted on:

28 Dec 2023

0

Thank you for your explanation, I understand👌

Submit an answer