Wall Street Prep

Nested (Two-Way) XLOOKUP vs Index Match Match [VIDEO and Excel File]

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

Two Way 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:

Submitting ...

2 Way Nested XLOOKUP in Action

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
guest
0 Comments
Inline Feedbacks
View all comments
X

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.