Wharton & Wall Street PrepWSP Certificates Now Enrolling for February 2025:
Private Equity•Real Estate Investing•Applied Value Investing•FP&A Wharton & Wall Street Prep Certificates:
Enrollment for February 2025 is Open →

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

Your Download is Ready

Submitting...

Turbo-charge your time in Excel Used at top investment banks, Wall Street Prep's Excel Crash Course will turn you into an advanced Power User and set you apart from your peers.

Learn More

Comments

Subscribe

0 Comments

Inline Feedbacks

View all comments

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

Learn More