VLOOKUP Questions

N

nyys

When using this function I've found that when the function cannot find the
value it's looking for, it returns the #N/A value.

I was wondering if there is a way for it to return a blank cell instead?

I've been plyaing around trying to embed the VLOOKUP in an IF function to
get the blank, but with no luck.

Any suggestions?
 
B

Belinda_Tim

Hello,

try

=if(isna(VLOOKUP(A1,I3:M11,2,FALSE)),0,VLOOKUP(A1,I3:M11,2,FALSE))

Then if #na comes up (ie it cannot find the value) it will replace the #na
with a 0 or anything else you want.

Cheers,
Bel
 
N

nyys

PERFECT! Thank you!

-paul

Belinda_Tim said:
Hello,

try

=if(isna(VLOOKUP(A1,I3:M11,2,FALSE)),0,VLOOKUP(A1,I3:M11,2,FALSE))

Then if #na comes up (ie it cannot find the value) it will replace the #na
with a 0 or anything else you want.

Cheers,
Bel
Click to expand...
 
Top