vlookup with data on more than one sheet

[Greegan]

i have a large excel file with a tab for every state or district and each
worksheet has US zip codes for (I'm sure) every city there is in the
country.
My problem is that I want two vlookup validation fields to reference all of
the worksheets.
One will type the city name in and the vlookup will give a list of all of
the city/states that will have that name with their zip codes (am i asking
too much?) and the other will be simpler... enter the zip code (5-digit) and
the city will appear with that zip code.

SOOOO... is there an easy way to have it reference all of the worksheets to
find the correct zip code or city/state?

much appreciated

G

 

[Myrna Larson]

One will type the city name in and the vlookup will give a list of all of

the city/states that will have that name with their zip codes (am i asking
too much?)

VLOOKUP returns only 1 value.

To and the other will be simpler... enter the zip code (5-digit) and
the city will appear with that zip code.
SOOOO... is there an easy way to have it reference all of the worksheets to
find the correct zip code or city/state?

No, you would need one formula for each worksheet.

To accomplish either of these tasks would require VBA macros.