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
April 15th, 2012 at 14:32
The solution is not too bad. It is, however, rather static. On my site I have already many years an example that is more dynamic, at least in my view. In mean time I have made even better solutions. It may be good to have a look. The explanation is in Dutch. If needed I could translate it.
See http://www.keesampt.com/files/keuzelijsten_op_2_niveaus.xls
or first http://www.keesampt.com/Service.html [the Dutch version] and there the file keuzelijsten_op_2_niveaus.