1. ## 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. ## Re: Vlookup? (2000 (SR-1))

Hi

Does the attached example help?

3. ## 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. ## 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. ## 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
•