VLOOKUP and multiple matches

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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.
 
Back
Top