Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: how to get rid of #NA?

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am using LOOKUP function to autofill cells, based on the selection of other cells in the same row.

    The problem is that if nothing is selected in the corresponding cells it shows #NA in the autofill (where i am using the LOOKUP function) cells

    Is there a solution to this problem? Thanks in advance for your help!

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What would you like it to do for you if the alternative is #N/A?

    You can use...

    =if(isna(myvookuphere),"whatifisna",myvlookuphereagain


    ~Anne Troy

  3. #3
    New Member
    Join Date
    May 2002
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Dreamboat. That works

    I've set it to " "(blank) if it's NA#

  4. #4
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    ~Anne Troy

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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