Scenario Analysis Using XLOOKUP [VIDEO]

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.

Download the Excel file that goes with this lesson below.

Get the Excel Template!

You’re logged in! Form submission not required. Access your file below.

Download File

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