Eliminating #N/A from VLOOKUP

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

Guest

I'm using VLOOKUP to compare two lists of names to see if the same name appears in both lists. Both lists are single columns. What I'd like to do is trade in those ugly #N/A designations for either an empty cell or the text string No Match
So, my question is as follows
How can I rewrite the formula to eliminate the #N/As
-or
Is there a formula better sutied to this task that I've overlooked

t
 
One way

=IF(ISNA(MATCH(A2,Sheet2!,A1:A50,0)),"No
Match",VLOOKUP(A2,Sheet2!A1:B50,2,0))

--

Regards,

Peo Sjoblom


tjtjjtjt said:
I'm using VLOOKUP to compare two lists of names to see if the same name
Click to expand...
appears in both lists. Both lists are single columns. What I'd like to do is
trade in those ugly #N/A designations for either an empty cell or the text
string No Match.
 
Back
Top