Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to look up zip codes
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 -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=503642 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |