Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for September 2024 for September 2024
Private EquityReal Estate Investing
Hedge Fund InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for September 2024 is Open
Wall Street Prep

Nested (Two-Way) XLOOKUP vs Index Match

Learn how to easily create a two-way nested XLOOKUP to replace Index Match Match formulas

Last Updated May 27, 2024

Learn Online Now

Two-Way Nested XLOOKUP

As we’ve discussed in a prior lesson, XLOOKUP is a game changer – replacing VLOOKUP and HLOOKUP and eliminating many use cases where more complicated INDEX MATCH functions needed to be used.

In this lesson, you will learn about how XLOOKUP can be used to replace INDEX MATCH when you need Excel to take two user defined inputs.

Download the Excel file that goes with this lesson below:


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


2 Way Nested XLOOKUP in Action [VIDEO]

Inline Feedbacks
View all comments
Learn Excel Online

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

Learn More

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.