Macro or Formula that Returns a Value Based on Adjacent Cells

[OliveTree]

I am looking for a formula or a macro that will fill a value in column B if the value in column A is matches any of a set of values.

For example, Mike manages John, Christine and Harriet and Susan manages Bob, Steve and Vicki. I have tried using nested IF formulas and they don't work right, as I have over 200 employees and 12 managers to match (too many conditions for a standard if formula) and the data is column A is dynamic; it's a formula pulling specific raw data from another sheet. I'm well versed with formulas, but still learning a lot of VBA and macros, any help is much appreciated.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Employee
[/TD]
[TD]Manager
[/TD]
[/TR]
[TR]
[TD]John
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bob
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Steve
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Harriet
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Christine
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Vicki
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Momentman]

Where do you have the information of who matches who? for example Mike manages John: meaning that in column B we should have mike as the manager for John right? But where do you have the raw data and in what format does it appear?

 

[Andrew Poulsom]

Welcome to MrExcel.

It sounds like you can use VLOOKUP:

http://www.contextures.com/xlFunctions02.html

 

[OliveTree]

Thanks! That worked perfectly, not sure why I didn't think of that before!

Welcome to MrExcel.

It sounds like you can use VLOOKUP:

http://www.contextures.com/xlFunctions02.html