I have tried to use the formula from this similar question but cannot seem to get this working. It's also more complicated that what I want but closest I could find to my question.
Data (formatted as a table "TeamList")
Name Emp#
Sally Doe 12345
John Doe 11234
John Doe 22345
James Doe 33456
Desired Result (on a different worksheet)
Emp#
12345
11234
22345
33456
The results (on a dashboard of sorts) would auto update as the source table is added to. I can index/match from there to gather the rest of the data, I just haven't been able to fill the Employee number from the table.
