Tag Archives: JPPinto

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