Novice at Excel - looking to place a value on a row based on a table value

[gandalf72]

Hi All, I am just starting out and trying to learn Excel, no idea about vbs sorry. I am thinking that I need to use a vlookup but just not sure how.

What I am essentially trying to do is if a persons name comes up on a column then assign the person who is looking after him.

Current
Current Username Person Responsible ian raymonde dirk Steven Ajith dirk Jon What I would like Username Person Responsible Person Responsible In Charge of In Charge of In Charge of ian Russell Russell Ian Raymonde Dirk Billy raymonde Russell Alastair Stuart Steven Jon dirk Russell Alex Ajith Sunil Mohamaed Steven Alastair Ajith Alex dirk Russell Jon Alastair <tbody> </tbody>
Any help much appreciated.

<colgroup><col><col><col span="2"><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[gandalf72]

hi Folks, don't know if I worded the above wrong or not but any advice would be much appreciated.

Essentially I am looking to search a column and if a name appears to put a name in a separate column. Can this be done?
Essentially I want to search column b and identify if Ian, Raymonde, Dirk or Billy appear to assign the name of Russell to column c. If Stuart, Steven or Jon appear in column b then in column C I would like Alastair to appear. Finally, if Ajith, Sunil Mohamad appear in column b I would like Alex to appear in column c

Any help much appreciated