Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: ISNA Function (2003)

    How about:
    =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. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: ISNA Function (2003)

    Hi There

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

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ISNA Function (2003)

    STEVE,

    PERFECT!

    Thank you so much! The first one was perfect!
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.

    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  6. #6
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    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>
    Jerry

Posting Permissions

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