Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Vlookup? (2000 (SR-1))

    I need to be able to type in a code like NA in one column and have it look for that value in another column on another sheet and then take the value from another column on the second sheet and put it on the first in a second column. Sort of like this:

    JOB___CODE____ PAY
    1234____NA_____ $17.00


    on the second sheet it would have:

    NA $17.00
    NU $27.50
    ND $45.00
    and so on

    I would type NA in the code column and it would return $17.00 in the pay column. I tried to use the VLOOKUP function but it didn't work correctly.

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

    Re: Vlookup? (2000 (SR-1))

    Hi

    Does the attached example help?

  3. #3
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vlookup? (2000 (SR-1))

    Yes! Thank you so much.

    If possible, can you also provide the LOOKUP formula for the same results? I'd like to try both to see which one works better for my needs.

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

    Re: Vlookup? (2000 (SR-1))

    LOOKUP does not have an option to specify an exact match, moreover it requires the code list to be sorted in ascending order, so you can't use LOOKUP here. An alternative to the VLOOKUP formula would be to use MATCH and INDEX:

    =INDEX(Sheet2!$B$1:$B$3,MATCH(B2,Sheet2!$A$1:$A$3, 0))

    MATCH looks for the value of B2 in Sheet2!$A$1:$A$3; the third argument 0 specifies that you want an exact match. MATCH returns 1 if the first cell matches, 2 if the second cell matches, etc., and #N/A if there is no match. INDEX then retrieves the appropriate value from Sheet2!$B$1:$B$3.

  5. #5
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vlookup? (2000 (SR-1))

    Thank you! Much appreciated!

Posting Permissions

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