Forum Discussion
Solved
Can Excel create a list?
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...
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.
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.
