Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP and multiple matches
Hello,
I have two tables - one with dealer numbers and zip codes (TABLE 1) and one with zip codes and several other columns (TABLE 2). I am trying to compare the two tables to get my dealer number to match on table 2. The problem I am having is that some of the zip codes on table 1 have multiple dealer numbers associated with it. Is there someway to get VLOOKUP to give me an error message if there is more than one exact match? I am in desperate need of help!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP and multiple matches
You can try something like this:
=IF(COUNTIF(zip_code_range,zip_code)1,"Error",VLO OKUP(...................)) Note that if the zip code doesn't exist at all the VLOOKUP function will return #N/A. -- Biff Microsoft Excel MVP "tamz33" wrote in message ... Hello, I have two tables - one with dealer numbers and zip codes (TABLE 1) and one with zip codes and several other columns (TABLE 2). I am trying to compare the two tables to get my dealer number to match on table 2. The problem I am having is that some of the zip codes on table 1 have multiple dealer numbers associated with it. Is there someway to get VLOOKUP to give me an error message if there is more than one exact match? I am in desperate need of help!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP and multiple matches
Thank you!
What would be my criteria (example) be? "T. Valko" wrote: You can try something like this: =IF(COUNTIF(zip_code_range,zip_code)1,"Error",VLO OKUP(...................)) Note that if the zip code doesn't exist at all the VLOOKUP function will return #N/A. -- Biff Microsoft Excel MVP "tamz33" wrote in message ... Hello, I have two tables - one with dealer numbers and zip codes (TABLE 1) and one with zip codes and several other columns (TABLE 2). I am trying to compare the two tables to get my dealer number to match on table 2. The problem I am having is that some of the zip codes on table 1 have multiple dealer numbers associated with it. Is there someway to get VLOOKUP to give me an error message if there is more than one exact match? I am in desperate need of help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can vlookup be used to retrieve multiple matches | Excel Discussion (Misc queries) | |||
Vlookup to return the sum of multiple matches | Excel Discussion (Misc queries) | |||
How do I get multiple matches when using the Vlookup function? | Excel Worksheet Functions | |||
Multiple matches on VLOOKUP | Excel Worksheet Functions | |||
how to deal with multiple matches on vlookup? | Excel Discussion (Misc queries) |