replace N/A by a blank

Y

yyy

How do i replace a #N/A that I get sometimes in a Vlookup by A blank ? or
the value if eveything is fine

TKS
 
J

JE McGimpsey

One way:


=IF(ISNA(MATCH(A1,Sheet2!A:A,FALSE)),"",VLOOKUP(A1,Sheet2!A:B,2,FALSE)
 
Top