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

AMEX

First Name *

Email *

Submit

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Email provided

Your Download is Ready

Submitting...