Oct 18 2021 10:26 AM
I have a training database. Personnel who's job code is ABC should be assigned the following training courses:
Avocado
Broccoli
Cantaloupe
I'd like to create a worksheet where a manager can enter a job code and have a list of required training classes for an employee populate in a table.
Can Excel generate a list based on a single data entry? Thank you.
Oct 18 2021 10:48 AM
Oct 18 2021 11:14 AM - edited Oct 18 2021 11:14 AM
OK, I've created a sample that uses a simple VLOOKUP formula and a table of course names with codes based on letters of the alphabet.
This works with job codes with 1 to 4 letters at the start of the Job Code.
The tables are dynamic, so you can add courses and names and see how it can grow.
By the way, this is only an example to show what's possible. It's by no means the only way to lay it out.
Oct 20 2021 04:35 PM
Thank you for the response and I apologize for the delay. I've provided some clarification in the attached. Let me know if this makes sense. Thank you again.
Oct 20 2021 05:13 PM
Solution
I'd recommend keeping the version I gave you as well, because it offers a LOT more flexibility. But here's the version you requested. Just a simple lookup.
Oct 20 2021 05:13 PM
Solution
I'd recommend keeping the version I gave you as well, because it offers a LOT more flexibility. But here's the version you requested. Just a simple lookup.