Reference Unique Values in Table

S

shaon814

New Member
Joined
Mar 23, 2017
Messages
10
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]
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Sort by date Sort by votes
This is an array formula and must be entered with CTRL-SHIFT-ENTER.
Drag formula down as needed.
Excel Workbook
ABCDEFGHI
1Data
2ManagerManager IDEmployeeEmployee ID
3Ben1458John1458
4Manager ID1234Mollie1234Hussain1468
5Manager NameMollieMollie1234Kayla1479
6Mollie1234Anna1369
7Employee 1 - Name1HussainSarah1224Clinton1258
8Employee 2 - Name2Kayla
9Employee 3 - Name3Anna
10
Sheet
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
hel separating
Replies
6
Views
747
Fluff
Fluff
J
  • Question Question
help find not 'exact'
Replies
1
Views
693
mumps
mumps
B
  • Question Question
Appending a Value to Each Element of a Range Array
Replies
7
Views
2K
Peter_SSs
Peter_SSs
J
  • Question Question
find dupes and hide non dupes
Replies
3
Views
696
Joe4
Joe4
J
  • Question Question
trouble with sorting by 'x' then 'z'
Replies
2
Views
735
NewTricks
N

Forum statistics

Threads
1,224,822
Messages
6,181,165
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top