Skip to main content
WSP Certificates with Columbia & Wharton Certificates Now Open! Now Open:
AI in Finance • Private Equity • FP&A •
Real Estate • Restructuring • Value Investing

Scenario Analysis Using XLOOKUP [VIDEO]

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

May. 27, 2024
1m Read

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.

Excel Template Icon

Get the Excel Template!

Comments

No comments yet.