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
Buy-Side InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for September 2024 is Open
Wall Street Prep

Scenario Analysis Using XLOOKUP [VIDEO]

Learn how to create a scenario analysis using XLOOKUP instead of traditional approaches like Index Match.

Last Updated April 5, 2023

Learn Online Now

Scenario analysis using XLOOKUP

XLOOKUP simplifies building a scenario analysis significantly.  Why does this matter? In corporate finance, one of the most common use cases for index match was building scenarios.

If this video goes a bit too fast, watch this video first.

Download the Excel file that goes with this lesson below.


Get the Excel Template!

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

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
most voted
newest oldest
Inline Feedbacks
View all comments
March 28, 2023 2:27 pm

He! I do not see the video. Is there a problem in this page? Thanks!

Brad Barlow
March 29, 2023 2:13 pm
Reply to  Francis

Hi, Francis,

Click on the ‘XLOOKUP’ hyperlink and it will take you to this page:


March 30, 2023 9:57 am
Reply to  Brad Barlow

He Brad, I did that before but goes to an explanation ox xlookup, not the one with Scenario Analisys like the title says “Scenario Analysis Using XLOOKUP [VIDEO]”.I thought it was something different.

Brad Barlow
April 1, 2023 6:29 am
Reply to  Francis

Hi, Francis,

I see what you are saying, and my apologies for missing that. I will inquire about this with our tech folks!


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.