jwbrouse01
New Member
- Joined
- Jun 2, 2022
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
I am trying something with an automatically-updating training matrix.
Sheet1 should be the training matrix, with employee names in column A, starting in row 2 and operation # in Row 1, Columns B-....
Sheet2 is the history of reviews that I have done for each employee. I have the following data:
Column A: Date
Column B: Employee name
Column C: operation #
Column D: Training Level
Each time I review an employee, I add the new training level assessment to the bottom of the list.
Back on Sheet1, I want to put a formula into each cell in my matrix that will automatically pull the level associated with each employee for each operation based on the last time they were evaluated. So basically, a lookup starting at the bottom of the page with criteria for employee name and operation #.
I know that I can do this with a UDF, but is there any way to achieve this with normal formulas that won't require a macro-enabled workbook?
Any assistance would be greatly appreciated!
Sheet1 should be the training matrix, with employee names in column A, starting in row 2 and operation # in Row 1, Columns B-....
Sheet2 is the history of reviews that I have done for each employee. I have the following data:
Column A: Date
Column B: Employee name
Column C: operation #
Column D: Training Level
Each time I review an employee, I add the new training level assessment to the bottom of the list.
Back on Sheet1, I want to put a formula into each cell in my matrix that will automatically pull the level associated with each employee for each operation based on the last time they were evaluated. So basically, a lookup starting at the bottom of the page with criteria for employee name and operation #.
I know that I can do this with a UDF, but is there any way to achieve this with normal formulas that won't require a macro-enabled workbook?
Any assistance would be greatly appreciated!