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
Wall Street Prep

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
most voted
newest oldest
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?

Learn Excel Online

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

Learn More

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.