VLOOKUP and multiple matches

[tamz33]

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!!

 

[T. Valko]

You can try something like this:

=IF(COUNTIF(zip_code_range,zip_code)>1,"Error",VLOOKUP(...................))

Note that if the zip code doesn't exist at all the VLOOKUP function will
return #N/A.

 

[tamz33]

Thank you!
What would be my criteria (example) be?