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.
Bookmarks