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 Excel-User.com as well as the fan page Excel User on Facebook and on Twitter @excel_user

About these ads

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 53 other followers

%d bloggers like this: