Good day,
I have a workbook where one of the tabs contains tables that feed the lookup on other tabs. The situation that I need assistance with relates to the supervisor of an employee for tracking and statistics. Until recently, the table had the employee name, employee number and name of their supervisor. With this, it was very easy to just use VLOOKUP to populate the other tabs as required. Now, I need to add another field that shows the date effective for a change of supervisor of the employee. I still need to have the previous supervisor listed to track activity under that previous supervisor.
What I am after is assistance with looking for is to take the name of the employee on Tab #1 and the date of the activity. Then go to the tab with all the information, look for the employee name and then choose the supervisor for that employee on the date from Tab #1 .
Example:
Joe Smith started a project on June 6, 2017. This is the information on Tab #1 . On the tab with the supervisory information, it shows that as of January 1, 2000 Joe Smith reported to Sam Brown and then as of July 15, 2016 he reported to Kris Silver. The field to be populated in Tab #1 should display Kris Silver. Joe Smith also has another entry on Tab #1 where this project started on May 1, 2016. This time, the supervisor information that will populate in Tab #1 would be Same Brown.
Any solutions to share?
Thanks in advance for your attention.
I have a workbook where one of the tabs contains tables that feed the lookup on other tabs. The situation that I need assistance with relates to the supervisor of an employee for tracking and statistics. Until recently, the table had the employee name, employee number and name of their supervisor. With this, it was very easy to just use VLOOKUP to populate the other tabs as required. Now, I need to add another field that shows the date effective for a change of supervisor of the employee. I still need to have the previous supervisor listed to track activity under that previous supervisor.
What I am after is assistance with looking for is to take the name of the employee on Tab #1 and the date of the activity. Then go to the tab with all the information, look for the employee name and then choose the supervisor for that employee on the date from Tab #1 .
Example:
Joe Smith started a project on June 6, 2017. This is the information on Tab #1 . On the tab with the supervisory information, it shows that as of January 1, 2000 Joe Smith reported to Sam Brown and then as of July 15, 2016 he reported to Kris Silver. The field to be populated in Tab #1 should display Kris Silver. Joe Smith also has another entry on Tab #1 where this project started on May 1, 2016. This time, the supervisor information that will populate in Tab #1 would be Same Brown.
Any solutions to share?
Thanks in advance for your attention.