"Vlook up + IF"

[paula smith]

I have created a function "vlook up" which worked fine,

 

[Guest]

One way:

=IF(ISERROR(yourVLOOKUPfunction),"",yourVLOOKUPfunction)

This would make the cell look empty instead of showing the error. It would
not fix the error, though.

tj

 

[Rob]

Paula,
using if(isna would trap NAs

=IF(ISNA((VLOOKUP(A2,A3:B6,2,FALSE))),"",VLOOKUP(A2,A3:B6,2,FALSE))

Regards, Rob