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

ID	Name	MGR ID	Manager Name
123	Bubba		None
124	Dooody		Bubba
125	Ho tep		Dooody
126	Elvis		Dooody
127	Alpha		Dooody
128	Alfa		Dooody
129	Gamma		Dooody
130	Boring		Dooody

<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[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