Help using VLOOKUP for data spread on 2 sheets

[GSmith8]

Im not sure whether to be using a VLookup or a countif or something else for the following

Sheet 1 has a Sender ID in Column B

This ID corresponds to a certain sender

Sheet 2 has a list of these Senders

Column A on sheet 2 has the Sender ID's
Column B has the Sender Names that correspond to the individual ID's

I need to do the following.

In column C on sheet 1 i need to return the Sender Name that corresponds to the Sender ID in Column B

Sheet1
B C
SenderID Sender Name
CL-MC-0012-07
CL-MC-0012-07
DHA-F-0000302


Sheet 2
A B
Sender ID Sender Name
CL-MC-0012-07 Sender 1
CL-MC-0012-07 Sender 2
DHA-F-0000302 Sender 3

Thanks in advance

[NeedForExcel]

Hey!

Please see the file attached.

Hope it helps.

Deep

[GSmith8]

Thanks for your reply.

The book you attached has info on sheet 1 and 2 but when i look at sheet 2 where it has names in the sender name column there is no formula or details. it is just names (as if they have been typed in manually)

[alansidman]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Tony Valko]

On Sheet2 you have duplicate Sender IDs with different Sender Names.

On Sheet1, how do you know which Sender Name corresponds to the Sender ID?

Maybe you need something like this:

http://www.excelforum.com/excel-form...ell-value.html