background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street PrepWSP Certificates Now Enrolling for February 2025:
Private EquityReal Estate InvestingApplied Value InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for February 2025 is Open

OFFSET MATCH and Data Validation, Part 2

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
Subscribe
Notify of
guest
3 Comments
Inline Feedbacks
View all comments
Brad Barlow
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

dave
dave
January 31, 2024 7:45 am

where the heck is the video?

ad image
Learn Excel Online

Become an Excel “Power User.” Used to train new hires at top financial institutions around the world!

Learn More