Vlookup that does not return #N/A

[Guest]

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

Thank you in advance.

 

[Guest]

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


Regards,

Peo Sjoblom

 

[Guest]

try =if(iserror(vlookup),"",Vlookup)

 

[Ron Rosenfeld]

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

Thank you in advance.

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


--ron