Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to add IS Error in formula (2000 sp3)

    Greetings!
    I have the following formula =(VLOOKUP(W2,Calendar!$A$1:$C$3489,3))-(VLOOKUP(F2,Calendar!$A$1:$C$3489,3))
    How do I use the ISERROR so that it will not show #N/A ?

    Thanks,
    Brad

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How to add IS Error in formula (2000 sp3)

    =IF(OR(ISNA(VLOOKUP(W2,Calendar!$A$1:$C$3489,3)),I SNA(VLOOKUP(F2,Calendar!$A$1:$C$3489,3))),"",VLOOK UP(W2,Calendar!$A$1:$C$3489,3)-VLOOKUP(F2,Calendar!$A$1:$C$3489,3))

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

    Re: How to add IS Error in formula (2000 sp3)

    Does this do what you want?

    <code>
    =IF(OR((ISERROR(VLOOKUP(W2,Calendar!$A$1:$C$3489,3 ))),ISERROR((VLOOKUP(F2,Calendar!$A$1:$C$3489,3))) ),"",(VLOOKUP(W2,Calendar!$A$1:$C$3489,3))-(VLOOKUP(F2,Calendar!$A$1:$C$3489,3)))
    </code>
    Legare Coleman

  4. #4
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to add IS Error in formula (2000 sp3)

    All,
    Both work great!

    Thanks,
    Brad

  5. #5
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    The Hague, Netherlands
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to add IS Error in formula (2000 sp3)

    Given your formula, #N/A can only occur when either W2 or F2 is smaller/less than Calendar!$A$1.

    If Calendar!$A$1:$C$3489 is sorted in ascending order on its first column, a state of affairs that justifies your setup for the VLOOKUP bits (No 4th arg, meaning 1 or TRUE), you don't need ISERROR()...

    Care to indicate what kind of stuff you have in Calendar!$A$1:$A$3489?
    Microsoft MVP - Excel

Posting Permissions

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