XLOOKUP vs. INDEX XMATCH in Excel | What is the Difference?

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 *

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

Submitting...

Comments

Subscribe

0 Comments

most voted

newest oldest

Inline Feedbacks

View all comments

Become an Excel “Power User.” Used to train new hires at top financial institutions around the world!