Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Harrisburg, Pennsylvania, USA
    Posts
    168
    Thanks
    1
    Thanked 0 Times in 0 Posts

    what if formula problem (excel 2000)

    What is problem with this "IF" formula. What must I do to check a range for a name and then report the results of another cell?

    Thanks for the help
    Attached Files Attached Files

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: what if formula problem (excel 2000)

    Personally I'd use the VLOOKUP function on this.

    =VLOOKUP(A5,A5:E8,5) entered in G5.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Harrisburg, Pennsylvania, USA
    Posts
    168
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: what if formula problem (excel 2000)

    Thanks Preston,

    That is a better way to go.
    Appreciate the help

  4. #4
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Harrisburg, Pennsylvania, USA
    Posts
    168
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: what if formula problem (excel 2000)

    Hello Preston,

    I just gave this a try with the Vlookup after I said it seemed like a better way to go. I entered the formula in cell G5 as suggested and got the result from one cell below the desired. Where might this be in error?

    Thanks again for the assist

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

    Re: what if formula problem (excel 2000)

    Preston accidentally forgot the last argument. it should be

    =VLOOKUP(A5,A5:E8,5,FALSE)

    FALSE means that you don't want an approximate match, but an exact one.

  6. #6
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: what if formula problem (excel 2000)

    Thanks!

  7. #7
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Harrisburg, Pennsylvania, USA
    Posts
    168
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: what if formula problem (excel 2000)

    this is a GREAT board.

    Thanks again all
    cvbs

Posting Permissions

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