Eliminating #N/A from VLOOKUP

[tjtjjtjt]

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

 

[Peo Sjoblom]

One way

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

--

Regards,

Peo Sjoblom

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.