RIP INDEX MATCH? Example Where XLOOKUP Loses

XLOOKUP has been crowned the new king of Excel reference functions, even defeating the mighty index match.

But it’s not a complete victory. Here is an example of Index Match (more accurately – INDEX XMATCH) doing something that XLOOKUP cannot:

Download the Excel file that goes with this lesson

First Name *

Email *

Submit

Email provided

Your Download is Ready

Submitting...