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>

							Data
							Manager Name	Manager ID	Employee Name	Employee ID
							Ben	1458	John	1458
	Manager ID		1234				Mollie	1234	Hussain	1468
	Manager Name		Mollie				Mollie	1234	Kayla	1479
							Mollie	1234	Anna	1369
Employee 1 - Name	1	Hussain					Sarah	1224	Clinton	1258
Employee 2 - Name	2	Hussain
Employee 3 - Name	3	Hussain

<tbody>
</tbody>

 

[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