M
mikeburg
Need formula to look up the zip codes listed in H2 thru K1522 when an
address is entered. For example:
In Cell B2 the following is entered:
2005 Airline Rd
Cell B3 return zip code:
75605
Zip code list:
_
__|____H____|___I___|__J__|__K___
_1|_Street___|__Zip__|Begin|_End__
10|_Adrian_Rd_|_75605_|_0000_|_0000
11|_Agness_Dr|_75602_|_0000_|_0000
12|_Airline_Rd_|_75603_|_0001_|_1999
13|_Airline_Rd_|_75605_|_2000_|_9999
14|_Akinships_|_75605_|_0000_|_0000
15|_Albertata_|_75605_|_0000_|_0000
16|_Aledo_Str_|_75604_|_0000_|_0000
17|_Alexander_|_75604_|_0000_|_0000_
The street name must not only be looked up, but if begin & end numbers
exists in colums J & K, they must be used to determine the zip code
too.
Thanks so very much for your help. mikeburg
address is entered. For example:
In Cell B2 the following is entered:
2005 Airline Rd
Cell B3 return zip code:
75605
Zip code list:
_
__|____H____|___I___|__J__|__K___
_1|_Street___|__Zip__|Begin|_End__
10|_Adrian_Rd_|_75605_|_0000_|_0000
11|_Agness_Dr|_75602_|_0000_|_0000
12|_Airline_Rd_|_75603_|_0001_|_1999
13|_Airline_Rd_|_75605_|_2000_|_9999
14|_Akinships_|_75605_|_0000_|_0000
15|_Albertata_|_75605_|_0000_|_0000
16|_Aledo_Str_|_75604_|_0000_|_0000
17|_Alexander_|_75604_|_0000_|_0000_
The street name must not only be looked up, but if begin & end numbers
exists in colums J & K, they must be used to determine the zip code
too.
Thanks so very much for your help. mikeburg