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]

Hi,

In cell C4 ... you could test following formula

=INDEX($A$1:$A$9,MATCH(D4,$B$1:$B$9,0))

Hope this will help

 

[psimpsonuml]

Hi,

In cell C4 ... you could test following formula

=INDEX($A$1:$A$9,MATCH(D4,$B$1:$B$9,0))

Hope this will help

So - this will populate D4 for everything in Column C, but I've got 400 rows to go through. Some people manage ~30 people, some manage 1.

 

[James006]

So I'm looking for a formula that takes "124" and populates it in C4-C9

So - this will populate D4 for everything in Column C

Sorry ... but I am lost ... which column do you need to populate ...???

 

[psimpsonuml]

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

Sorry
I want C2 to Identify the two matching names in B and D column, and pull in the ID matching the name. See below

ID	Name	MGR ID	Manager Name
123	James006	128	Alpha
124	PSIMPSONUML	129	Gamma
125	Ho tep	124	PSIMPSONUML
126	Elvis	124	PSIMPSONUML
127	Alpha	124	PSIMPSONUML
128	Alfa	123	James006
129	Gamma	123	James006
130	Boring	123	James006

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[mohadin]

ID	Name	MGR ID	Manager Name
123	James006	128or127?	Alpha
124	PSIMPSONUML	129	Gamma
125	Ho tep	124	PSIMPSONUML

<tbody>
</tbody>

 

[psimpsonuml]

127

 

[mohadin]

So
the formula provided should work Ok

C2=IFERROR(INDEX($A$2:$A$9;MATCH(D2;$B$2:$B$9;0));"")

 

[James006]

@ psimpsonuml


Remain curious to know what is final outcome ...

 

[psimpsonuml]

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