I have two spreadsheets and need to perform a complex lookup.
One sheet contains:
Employee Last Name
Employee First Name
Employee ID
Manager ID
Director ID
The second sheet contains:
Employee Last Name
Employee First Name
I have been tasked with trying to come up with a way to use the Employee Last Name and possibly the Employee First Name from the second sheet to locate that same employees name on the first sheet then get the corresponding Manager ID for that employee from the first sheet and search for the Manager ID in the Employee ID column on the first sheet to obtain the First and Last name of the manager and fill cells on the second sheet with the manager first and last name. Anyone have any ideas? I am familiar with VLOOKUPs but I have not found a way to perform this operation.
One sheet contains:
Employee Last Name
Employee First Name
Employee ID
Manager ID
Director ID
The second sheet contains:
Employee Last Name
Employee First Name
I have been tasked with trying to come up with a way to use the Employee Last Name and possibly the Employee First Name from the second sheet to locate that same employees name on the first sheet then get the corresponding Manager ID for that employee from the first sheet and search for the Manager ID in the Employee ID column on the first sheet to obtain the First and Last name of the manager and fill cells on the second sheet with the manager first and last name. Anyone have any ideas? I am familiar with VLOOKUPs but I have not found a way to perform this operation.