# Thread: ISNA (xl 2k but probably all)

1. ## ISNA (xl 2k but probably all)

I'm trying to replace the #N/A error message generated from a Vlookup when the target doesn't exist by the value zero.
My formula, of the type
=IF(isna(VLOOKUP(A4,Oct03!\$A:\$B,2,FALSE),0,VLOOKUP (A4,Oct03!\$A:\$B,2,FALSE))
fails. (the FALSE condition is there to force only an exact match, if there is one.)
It looks amazingly like one quoted by HansV in post 402652 -
=IF(ISNA(VLOOKUP(...),"",VLOOKUP(...))
What am I doing wrong?
Thanks.

2. ## Re: ISNA (xl 2k but probably all)

You forgot a close parentheses for the isna:
=IF(ISNA(VLOOKUP(A4,Oct03!\$A:\$B,2,FALSE)<font color=red>)</font color=red>,0,VLOOKUP(A4,Oct03!\$A:\$B,2,FALSE))

Steve

3. ## Re: ISNA (xl 2k but probably all)

What do you mean by the formula fails? Do you get an error message? If so, what error? Do you get results that you do not expect? If so, what?

The formula in your message does not have balanced parenthesis. There is one more left parenthesis that right parenthesis. Therefore, this formula could not have been entered into a cell. That makes it a little difficult for us to guess what is going on. The formula below, with the parenthesis corrected, seems to do what you are asking:

<pre>=IF(ISNA(VLOOKUP(A4,Oct03!\$A:\$B,2,FALSE)),0,V LOOKUP(A4,Oct03!\$A:\$B,2,FALSE))
</pre>

4. ## Re: ISNA (xl 2k but probably all)

Thanks very much, both!
Your identical solutions to my carelessness are appreciated.
Steve's works, I haven't tested Legare's **grin**

5. ## Re: ISNA (xl 2k but probably all)

I tested it. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•