JP Pinto: “Cascading Validation Lists w/ VLookup”

JP Pinto checks in from Setúbal, Portugal and sends in a functional and very handy use of VLookup. As JP Pinto posts:

“Here’s the scenario: on our worksheet, we want to choose a Country and the corresponding City. We want to limit the countries available to the user as well as the cities that they can choose. For start, we want to choose the country and on the second cell we can only put cities that correspond to that country. It makes sense, right?”… To Read More Click Here to go to JP Pinto’s Lesson

JP Pinto may be found at as well as the fan page Excel User on Facebook and on Twitter @excel_user

About MrExcel East

Facilitator | Image Virtuoso | Tweet-Jacker | Permuted Floridian | View all posts by MrExcel East

One response to “JP Pinto: “Cascading Validation Lists w/ VLookup”

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: