| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
VLOOKUP with duplicate returns
I've created a vlookup to pull state and county when a zip code is entered.
Problem is that some zip codes are in multiple counties. for example: I live in 54115, which is in Brown and Outagamie counties. the lookup only returns Brown as it is listed first alphabetically (I assume). Any formula I can add to let the user know of error or that multiple options/counties are available? Thanks again |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup finds a blank, but returns a zero - HELP! | Excel Discussion (Misc queries) | |||
| When VLOOKUP returns a #N/A How can you get it to replace #N/A wi. | Excel Worksheet Functions | |||
| Vlookup returns incorrect match | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| vlookup returns n/a | Excel Worksheet Functions | |||
Threaded Mode
