Exit to Learning Dashboard

OFFSET MATCH and Data Validation, Part 2

Sep. 17, 2022
1m Read

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.

Click here to go to part 1 of this Quick Lesson

Click here to download the Excel template that goes with this video.

Comments
dave
January 31, 2024 7:45 am

where the heck is the video?

Brad Barlow
April 15, 2024 9:17 pm
Brad Barlow
April 15, 2024 9:14 pm

Hi, All,

For those looking for the video for this lesson, please check out this link to both videos: https://www.wallstreetprep.com/quicklesson/offsetmatch-and-data-validation/

BB