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.
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.
He! I do not see the video. Is there a problem in this page? Thanks!
Hi, Francis,
Click on the ‘XLOOKUP’ hyperlink and it will take you to this page: https://www.wallstreetprep.com/knowledge/xlookup-in-excel-why-it-rocks-and-comparison-to-vlookup-and-index-match-video/
BB
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.
Hi, Francis,
I see what you are saying, and my apologies for missing that. I will inquire about this with our tech folks!
BB