Last answered:

14 Sept 2022

Posted on:

14 Sept 2022

0

Resolved: x lookup question vs nested functions.

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

1 answers ( 1 marked as helpful)
Instructor
Posted on:

14 Sept 2022

0

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

Submit an answer