Financial Modeling Quick Lessons: Integrating Scenarios w/ OFFSET/MATCH (Part 1) [UPDATED]

Note: To download the Excel template that goes with this video, go to www.wallstreetp...
In this video, I'll show you how to integrate scenarios into financial models.
We'll do this by building a drop down menu in Excel using data validation and connecting the drop down menu to the scenario analysis using the OFFSET / MATCH function.

[@JDWilliamsPD]

Bravo! It's weird that something this good does not have tens of thousands of hits.

[@mikedulrich]

I've done something similar before using INDEX and MATCH instead of offset. Here's a single formula you could use to get the values for F13:H16, no copy/paste or fill required; just enter the formula in F13 and it will spill the result in the other cells:
=INDEX(F21:H36,MATCH(B13:B16,B21:B36,0)+MATCH(D18,B21:B36,0)-1,SEQUENCE(,3))
(I think I got the cell references to match the sheet in the video but I did it by hand)

[@louiscowell4003]

Great video, thanks for posting. The CHOOSE (with MATCH) function is another way to go.

[@Bestafghanboy]

Exceptional 😊

[@mohamedsaleh7196]

Nicely done

[@hpber]

fantastic

[@tryme113]

Love it