OFFSET MATCH and Data Validation, Part 1

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 2 of this Quick Lesson.

Before we begin: Get the Excel template file

Use the form below to get the Excel template file used in this lesson:

AMEX

First Name *

Email *

Submit

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Email provided

Your Download is Ready

Submitting...