Vlookup that does not return #N/A

C

carl

Is there a way to modify the vlookup formula so that it return a blank versus
#N/A.

Thank you in advance.
 
P

Peo Sjoblom

=IF(ISNUMBER(MATCH(A1,B1:B100,0)),VLOOKUP(A1,B1:C100,2,0),"")


Regards,

Peo Sjoblom
 
R

Ron Rosenfeld

Is there a way to modify the vlookup formula so that it return a blank versus
#N/A.

Thank you in advance.
Click to expand...


=IF(ISNA(your_vlookup_formula),"",your_vlookup_formula)


--ron
 
Top