LOOKUP?
I need to match a 5-digit zip code with a person responsible for that area.
For instance, if I type in 49494, and I have a person responsible for the
entire 494 area, I'd like to return the value (person) who has that area
without have to do a matchup for each individual zip code. For instance:
I type in 49494. I have another list that shows this:
490 - Smith
491 - Jones
492 - Hayes
493 - Gates
494 - Doe
Thanks in advance!
|