Reference Unique Values in Table

[shaon814]

Hi,

I'm trying to pull in the Employee Name based on a Manager's ID Number.

For example, if I type in 1234 - I want the table below to fill out with all of her direct reports. But with Index Match, it only pulls in the first result. Is there a way to pull in the new next result and keep going until there isn't a difference?

-Thanks!


<style type="text/css"> p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 11.0px Calibri; min-height: 13.0px} p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 11.0px Calibri; color: #ffffff } p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 11.0px Calibri; color: #ffffff ; min-height: 13.0px} p.p4 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 11.0px Calibri} table.t1 {border-collapse: collapse} td.td1 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px} td.td2 {background-color: #000000 ; border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px} </style>[TABLE="class: t1"]
<tbody>[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td2"]Data
[/TD]
[TD="class: td2"]

[/TD]
[TD="class: td2"]

[/TD]
[TD="class: td2"]

[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]Manager Name
[/TD]
[TD="class: td1"]Manager ID
[/TD]
[TD="class: td1"]Employee Name
[/TD]
[TD="class: td1"]Employee ID
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]Ben
[/TD]
[TD="class: td1"]1458
[/TD]
[TD="class: td1"]John
[/TD]
[TD="class: td1"]1458
[/TD]
[/TR]
[TR]
[TD="class: td2"][/TD]
[TD="class: td1"]Manager ID
[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]1234
[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]Mollie
[/TD]
[TD="class: td1"]1234
[/TD]
[TD="class: td1"]Hussain
[/TD]
[TD="class: td1"]1468
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]Manager Name
[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]Mollie
[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]Mollie
[/TD]
[TD="class: td1"]1234
[/TD]
[TD="class: td1"]Kayla
[/TD]
[TD="class: td1"]1479
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]Mollie
[/TD]
[TD="class: td1"]1234
[/TD]
[TD="class: td1"]Anna
[/TD]
[TD="class: td1"]1369
[/TD]
[/TR]
[TR]
[TD="class: td1"]Employee 1 - Name
[/TD]
[TD="class: td1"]1
[/TD]
[TD="class: td1"]Hussain
[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]Sarah
[/TD]
[TD="class: td1"]1224
[/TD]
[TD="class: td1"]Clinton
[/TD]
[TD="class: td1"]1258
[/TD]
[/TR]
[TR]
[TD="class: td1"]Employee 2 - Name
[/TD]
[TD="class: td1"]2
[/TD]
[TD="class: td1"]Hussain
[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[/TR]
[TR]
[TD="class: td1"]Employee 3 - Name
[/TD]
[TD="class: td1"]3
[/TD]
[TD="class: td1"]Hussain
[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]

[/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

This is an array formula and must be entered with CTRL-SHIFT-ENTER.
Drag formula down as needed.

Excel Workbook
	A	B	C	D	E	F	G	H	I
1						Data
2						Manager	Manager ID	Employee	Employee ID
3						Ben	1458	John	1458
4		Manager ID		1234		Mollie	1234	Hussain	1468
5		Manager Name		Mollie		Mollie	1234	Kayla	1479
6						Mollie	1234	Anna	1369
7	Employee 1 - Name	1	Hussain			Sarah	1224	Clinton	1258
8	Employee 2 - Name	2	Kayla
9	Employee 3 - Name	3	Anna
10
Sheet