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)
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
Exactly, I have the same Question!
why do we use INDEX, MATCH, MATCH, and not simply INDEX, MATCH?
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:
Hope this helps.
Kind regards,
Martin
Thank you for your explanation, I understand👌