"Vlook up + IF"
 

I have created a function "vlook up" which worked fine,
however I would like to add the function "if" to avoid
have some cells N/A instead of a number (zero). How I
could do that?
thanks in advance for your help,
Paula

One way:

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

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

tj

"paula smith" wrote:

I have created a function "vlook up" which worked fine,
however I would like to add the function "if" to avoid
have some cells N/A instead of a number (zero). How I
could do that?
thanks in advance for your help,
Paula

Paula,
using if(isna would trap NAs

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

Regards, Rob

"paula smith" wrote in message
...
I have created a function "vlook up" which worked fine,
however I would like to add the function "if" to avoid
have some cells N/A instead of a number (zero). How I
could do that?
thanks in advance for your help,
Paula