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.

[TABLE="width: 652"]
<colgroup><col><col><col span="2"><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Current[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 652"]
<tbody>[TR]
[/TR]
[TR]
[TD]Current[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Username[/TD]
[TD]Person Responsible[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ian[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]raymonde[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]dirk[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Steven[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Ajith[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]dirk[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jon[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]What I would like[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Username[/TD]
[TD]Person Responsible[/TD]
[TD][/TD]
[TD][/TD]
[TD]Person Responsible[/TD]
[TD]In Charge of[/TD]
[TD]In Charge of[/TD]
[TD]In Charge of[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ian[/TD]
[TD]Russell[/TD]
[TD][/TD]
[TD][/TD]
[TD]Russell[/TD]
[TD]Ian[/TD]
[TD]Raymonde[/TD]
[TD]Dirk[/TD]
[TD]Billy[/TD]
[/TR]
[TR]
[TD]raymonde[/TD]
[TD]Russell[/TD]
[TD][/TD]
[TD][/TD]
[TD]Alastair[/TD]
[TD]Stuart[/TD]
[TD]Steven[/TD]
[TD]Jon[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]dirk[/TD]
[TD]Russell[/TD]
[TD][/TD]
[TD][/TD]
[TD]Alex[/TD]
[TD]Ajith[/TD]
[TD]Sunil[/TD]
[TD]Mohamaed[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Steven[/TD]
[TD]Alastair[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Ajith[/TD]
[TD]Alex[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]dirk[/TD]
[TD]Russell[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jon[/TD]
[TD]Alastair[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Any help much appreciated.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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