Help with a formula that will recognise identical unique identifiers more than once.

Hi
Here is my dilemma

I am currently using Index Lookup to bring in data.

My problem is I have numerous unique identifiers, names for example and they have different employee numbers. Is there a formula that I can insert to say something like the following-
If you see the unique identifiers once then bring them in once
If you see the unique identifier again then bring in the next value.

In the attached sheet I want to bring in the correct payroll for the person in the correct location from the All Data tab into the Bring in here tab.

I hope Im not confusing anyone, this is my first time posting.