I need help with VLOOKUP

Hello,

I'm trying to edit a long list of accounts and insert the rep name into the list by the rep code. Column D shows rep codes and may have any number of a given code. I've moved the list of rep codes by name (1 each) into Coulmns J & K. I would like to move the proper name into column E. I believe VLOOKUP is the proper formula but I can't figure it out. Help!

Thanks,

Todd

Thanks for responding. I ultimately got it to work with trial and error but I don't fully understand the formula yet. I can't upload an example as this is sensative data. Basically I have one Sheet with with Rep Names and Rep Numbers. Reps have more than one rep number. I have another sheet with Rep Numbers and assets by account. I need to get the rep names into each line on the 2nd sheet. Rather than sorting by rep number and pasting in rep names for 16k lines, I moved in the column of Rep Names and Rep Numbers (523 lines) and created the following setup.

I want a formula (say in column D) to Identify the rep code in the adjacent cell (C), then look for that number in another column (A), and then take the name from the adjecent cell (B) and place it in D. At 1st I didn't understand that the rep codes I wanted to search through needed to be in A. But here is the formula that ultimatley worked (in cell D2 and then pasted throughout the column):

=VLOOKUP(C2,A2:B523,2,FALSE)

I don't know if that was the best way to do it. What is with all the "$" symbols that everyone uses in VLOOKUP examples?

Thanks again.

As you already found out vlookup works from left to right.

In your case it is easy to put the columns in the correct order so that the rep number is the first column in the range but if you couldn't change the order for a reason or another, you could use index and match instead of vlookup. I have attached an example (2007)for you to look but basically the formula then looks like this

=INDEX($A$2:$B$9,MATCH(H2,$B$2:$B$9,0),1)

where A2:B9 is your rep name/number grid and H2 is the rep number in your destination sheet.The match part works out the row number and the last argument is the column. You can make it look in more than just column 1 for the result by using a match function there too if you need.

Have a play with the attached example by moving things around and it will soon make sense.example using index and match.xlsx

Thanks so much! I should have signed up for this site years ago!

Thanks for the suggestion. I'm trying to use this Index/Match process for something else. In this case I need to Aggregate the rep codes into one cell. In your example the assets results are all on a seperate line, but I now need to look up all rep codes and joint rep codes and have the results put together. Is this possible?

I've got it solved now. Thanks.