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

[@JDWilliamsPD]

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

[@louiscowell4003]

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

[@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)

[@Bestafghanboy]

Exceptional 😊

[@mohamedsaleh7196]

Nicely done

[@tryme113]

Love it

[@hpber]

fantastic