background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
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 →
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

  Updated Jul. 18, 2024
  0m Read Time
  Table of Contents
  1. Two-Way Nested XLOOKUP
  2. Two-Way Nested XLOOKUP — Excel File Lesson
  3. 2 Way Nested XLOOKUP in Action [VIDEO]

Two-Way Nested XLOOKUP

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.

Two-Way Nested XLOOKUP — Excel File Lesson

dl

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

Your Download is Ready
Submitting...

2 Way Nested XLOOKUP in Action [VIDEO]

Related Posts
Using XLOOKUP to Generate Multiple Values
5-Min Read →
Using XLOOKUP to Generate Multiple Values
Scenario Analysis Using XLOOKUP [VIDEO]
5-Min Read →
Scenario Analysis Using XLOOKUP [VIDEO]
XLOOKUP Function
7-Min Read →
XLOOKUP Function
Comments
Subscribe
Notify of
0 Comments
most voted
newest oldest
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.