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.