Wharton & Wall Street Prep Private Equity Certificate: Now Accepting Enrollment for May 1-June 25 →
Wall Street Prep

Scenario Analysis Using XLOOKUP [VIDEO]

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

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.

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
Inline Feedbacks
View all comments

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.