Populating Manager IDs? Vlookup?

[psimpsonuml]

Hey all,

I've got this list of Employee ID - Employee Name - MGR ID - Manager Name. 1400 employees, ~400 managers.

I'm looking for a formula or function or feature - SOMETHING that will allow me to populate the Manager ID. I know VLOOKUP would work if it was a 1:1 relationship but as the dummy example I made below shows - There are 6 employees who share the same manager so I'm looking for a formula that takes "124" and populates it in C4-C9

[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]ID[/TD]
[TD="width: 64"]Name[/TD]
[TD="width: 64"]MGR ID[/TD]
[TD="width: 64"]Manager Name[/TD]
[/TR]
[TR]
[TD="align: right"]123[/TD]
[TD]Bubba[/TD]
[TD][/TD]
[TD]None[/TD]
[/TR]
[TR]
[TD="align: right"]124[/TD]
[TD]Dooody[/TD]
[TD][/TD]
[TD]Bubba[/TD]
[/TR]
[TR]
[TD="align: right"]125[/TD]
[TD]Ho tep[/TD]
[TD][/TD]
[TD]Dooody[/TD]
[/TR]
[TR]
[TD="align: right"]126[/TD]
[TD]Elvis[/TD]
[TD][/TD]
[TD]Dooody[/TD]
[/TR]
[TR]
[TD="align: right"]127[/TD]
[TD]Alpha[/TD]
[TD][/TD]
[TD]Dooody[/TD]
[/TR]
[TR]
[TD="align: right"]128[/TD]
[TD]Alfa[/TD]
[TD][/TD]
[TD]Dooody[/TD]
[/TR]
[TR]
[TD="align: right"]129[/TD]
[TD]Gamma[/TD]
[TD][/TD]
[TD]Dooody[/TD]
[/TR]
[TR]
[TD="align: right"]130[/TD]
[TD]Boring[/TD]
[TD][/TD]
[TD]Dooody[/TD]
[/TR]
</tbody>[/TABLE]

 

[James006]

What do you mean by

" seems to be causing an error " ....

 

[Fluff]

How about

Book1
	A	B	C	D
1	ID	Name	MGR ID	Manager Name
2	123	James006	127	Alpha
3	124	PSIMPSONUML	Not found	Beta
4	125	Ho tep	124	PSIMPSONUML
5	126	Elvis	124	PSIMPSONUML
6	127	Alpha	124	PSIMPSONUML
7	128	Alfa	123	James006
8	129	Gamma	123	James006
9	130	Boring	123	James006
Lookup

Cell Formulas
Range	Formula
C2	=IFERROR(INDEX($A$2:$A$500,MATCH(D2,$B$2:$B$500,0)),"Not found")

 

[psimpsonuml]

This worked (aside from Employee Column having middle initials and manager column not having it). Thank you so much! All of the "Experts" I work told me it was impossible and that I had to manually do it.

Can you explain the logic in the formula for my future use?

 

[James006]

This did not work. $A$2:$A$9 seemed to be causing an error

Impressive ... !!!

12 Messages to discover 9 had to be changed to 500 ...

 

[Fluff]

To understand the formula, have a look here https://exceljet.net/index-and-match