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?

Try something like: =IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"nyys" wrote in message
...
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?

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

"nyys" wrote:

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?

PERFECT! Thank you!

-paul

"Belinda_Tim" wrote:


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

"nyys" wrote:

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?

You're on the right track... =if(isna(vlookup(...)),"",vlookup()).
--Bruce

"nyys" wrote:

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?