Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Feb 2004
    Location
    Jacksonville, Florida
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts

    vlookup function (2000)

    I'm trying to get cells in column A of sheet one to lookup (match itself) to column A of sheet 2 and return the value associated in column b of sheet 2. The formula I am using is =vlookup(A2,sheet2!a:c,2) with a logic of false. But it keeps returning the number 6, which I know should only either be a 0,1,2, or 3. Can anyone help me out with my formula dilema?

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

    Re: vlookup function (2000)

    This formula works for me:

    <pre>=VLOOKUP(A1,Sheet2!A:C,2,FALSE)
    </pre>


    If you are doing an exact lookup, you need the fourth parameter FALSE.
    Legare Coleman

  3. #3
    Star Lounger
    Join Date
    Feb 2004
    Location
    Jacksonville, Florida
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vlookup function (2000)

    I have that formula typed in, but it's returning 6 for every cell, and there isn't even a 6 in the column I want it to return...here's the file I'm working with. I want the id on sheet one to be matched and paired with the corresponding priority number on sheet 2. Maybe by seeing what I'm doing, it'll be easier to know what I'm doing wrong.... Thank you in advance for any and all help...

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: vlookup function (2000)

    If the value you want to look up is in column C then the formula should be:

    =VLOOKUP(A1,Sheet2!A:C,3,FALSE)

    Your current formula looks up the hidden column B for the result and that does contain 6

  5. #5
    Star Lounger
    Join Date
    Feb 2004
    Location
    Jacksonville, Florida
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vlookup function (2000)

    Wow!!! Do I feel like a niencumpoop!!!!!!! Thank you

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

    Re: vlookup function (2000)

    Your Sheet2 has column B hidden, and that is what your formula is returning. If you want to return column C, then use:

    <pre>=VLOOKUP(A2,Sheet2!A:C,3,FALSE)
    </pre>

    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
  •