1. ## ISNA Function (2003)

When I use the: =VLOOKUP(A2,TABLE2,2) function in cell B2 to lookup what I type in cell A2 in a range I named TABLE2, and tell me what's in the 2nd column, all works well. I autofill that down column B. Until I actually put something in A3 A4, A5 etc...the formula returns the NA result. I think I have to use the ISNA in front of the VLOOKUP, but when I type it like =ISNA(VLOOKUP(A2,TABLE2,2),0,FALSE)) And every other combination i have tried...It doesn't work. What I'd actually like to happen is for NOTHING to be in the autofilled area (column until I do type somethin into column A.
Appreciate any feedback

2. ## Re: ISNA Function (2003)

=if(isna(VLOOKUP(A2,TABLE2,2)),"",VLOOKUP(A2,TABLE 2,2))

or if you only want to check for blank A2:
=if(A2="","",VLOOKUP(A2,TABLE2,2))

Steve

3. ## Re: ISNA Function (2003)

Hi There

Can you use
=IF(ISNA(VLOOKUP(A2,Table2,2,FALSE)),"",VLOOKUP(A2 ,Table2,2,FALSE))

4. ## Re: ISNA Function (2003)

STEVE,

PERFECT!

Thank you so much! The first one was perfect!

5. ## Re: ISNA Function (2003)

Jezza,

Guess it doesn't matter which way you write it. Both your version and Steve's version do exactly the same thing. Thank you so much! I am always humbled by all you know.

6. ## Re: ISNA Function (2003)

No problems

I was just taking longer to write the answer and had not realised Steve had answered. That is what happens when I am in the Lounge and watching a film <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

#### Posting Permissions

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