Dropdown list effects multiple dropdown list

[pvaldez]

I'm familiar with creating a dropdown list in excel where a selected item will effect the list of another dropdown list, using a INDIRECT(VLOOKUP) formula. Is there a way, using the same, or similar formula whereby select an item in the first dropdown, will change the selection list in multiple other dropdowns?
An example would be:
Say I have three dropdown lists, (I'll most like have more, however, I'll just use three for this example). The first dropdown will be a list of STATES, the second will display CITIES, and the Third will display the corresponding ZIP CODES of the Selected city.

I am currently using Excel 2007 however, when using Data Validation, don't think it makes a difference.

Any help is greatly appreciated.

[NBVC]

You would have to create named ranges for each State showing the specific Cities in each range...then you would need named ranges for each city showing the specific zipcodes.

See http://www.contextures.com/xlDataVal02.html