background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wall Street Prep WSP Certificates with Columbia & Wharton Certificates Now Open! Now Enrolling:
AI in Business & Finance Private Equity FP&A
Real Estate Investing Investing Value Investing

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
3 Comments
Inline Feedbacks
View all comments
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
January 31, 2024 7:45 am

where the heck is the video?

Brad Barlow
April 15, 2024 9:17 pm
Reply to  dave
ad image
Learn Excel Online

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

Learn More