Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    iserror - error (2003)

    Lounger,

    I need your help again. I'm trying to use "iserror" to remove the N/A from a cell using the formula below:-

    =if(iserror(IF(G10="","",IF(H10="","",IF(H10>0,(VL OOKUP(CONCATENATE(G10&H10),(Lookup!C32:G56),4,FALS E)),))),"",IF(G10="","",IF(H10="","",IF(H10>0,(VLO OKUP(CONCATENATE(G10&H10),(Lookup!C32:G56),4,FALSE )),)))

    However I get a message saying the formula contains an error.

    Has anybody got any suggests as to the problem?

  2. #2
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Re: iserror - error (2003)

    Thanks Legare,

    That works fine - I see where I made the error

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: iserror - error (2003)

    Without your workbook I can't determine what the formula is supposed to do. However, the version below does not get an error, I just don't know if it does what you want.

    <pre>=IF(ISERROR(IF(G10="","",IF(H10="","",IF(H10> 0,(VLOOKUP(CONCATENATE(G10&H10),
    (Lookup!C32:G56),4,FALSE)),)))),"",IF(G10="","",IF (H10="","",IF(H10>0,
    (VLOOKUP(CONCATENATE(G10&H10),(Lookup!C32:G56),4,F ALSE)),))))
    </pre>

    Formula broken into three lines by HansV because it caused horizontal scrolling. It should be entered as one line, however.
    Legare Coleman

Posting Permissions

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