Resolved: x lookup question vs nested functions.

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

Hi, is Xlookup a sufficiant subtitude for INDEX $ MATCH? And what about Xlookuo vs INDEX & MATCH, MATCH..? Thanks..!

1 answers ( 1 marked as helpful)

Ned Krastev

Instructor

Posted on:

14 Sept 2022

Hi,
Great to hear from you!
Yes, XLOOKUP is a sufficient substitute of INDEX & MATCH. I don't think it can substitute INDEX, MATCH, MATCH though.
Best,
Ned

Helpful answer

Resolved: x lookup question vs nested functions.

Submit an answer

related questions