Here is the scenario... I have a list of employees and all of the training courses they have completed through the first quarter of 2020. Each employees completed training courses are listed on its own sheet. On another sheet i have a table of all the required training courses. How can I easily/quickly run a formula to indicate which training courses each employee has not completed thus far?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Need Help
- Thread starter rwendel
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,244
- Office Version
- 365
- Platform
- Windows
Welcome to the Board!
A lot is dependent upon the actual structure of the data, but one way might be to do something like this:
- List employees down column A
- List all required training courses across row 1
- Write VLOOKUP formulas to look up each person/course combination, and see if they have taken the course. You can wrap that VLOOKUP in an IFERROR function to indicate courses needed to be taken, i.e. something structured like this:
=IFERROR(VLOOKUP(...),"NOT COMPLETED")
If you would like more specific help, we will need more details. Note that you can post images of your data using the tool mentioned here: XL2BB - Excel Range to BBCode
A lot is dependent upon the actual structure of the data, but one way might be to do something like this:
- List employees down column A
- List all required training courses across row 1
- Write VLOOKUP formulas to look up each person/course combination, and see if they have taken the course. You can wrap that VLOOKUP in an IFERROR function to indicate courses needed to be taken, i.e. something structured like this:
=IFERROR(VLOOKUP(...),"NOT COMPLETED")
If you would like more specific help, we will need more details. Note that you can post images of your data using the tool mentioned here: XL2BB - Excel Range to BBCode
Upvote
0
Similar threads
- Question
