jonnybigood
New Member
- Joined
- Feb 26, 2012
- Messages
- 3
First off I apologize if this has already been figured out. I am trying to figure out a formula that takes a zip code and gives me the zone it falls into. Column A would contain a range that looks like 004-005 and the columns after in the same row would contain the zone. ex: Range Zones 384-385 007 307 207 247 137 107 386-392 006 306 206 246 136 106 393-418 007 307 207 247 137 107 420 006 306 206 246 136 106 421-422 007 307 207 247 137 107 Given the zip code is there a way to look thru these to give the correct zones without using VBA code? Any help would be appreciated. Thanks. Edited to try to show where each new row starts but it deletes my carriage returns. the range can be listed like 000-000 or just 000 if that makes any sense.
Last edited: