Best method to create training log?

I'm trying to create a staff training log in excel. I've tried various methods and none of them are really getting me 100% to where I want to be.

My requirements are:

- Staff List
- Course List
- Ability to select staff member from dropdown, a list will appear detailing the courses they have taken
- Ability to select course from a dropdown, a list will appear detailing the staff members that have taken this course

Methods I've Tried:

- VLOOKUP
- Data Validation
- Pre-existing template
- Filters

I feel like each of these methods is getting me close but I always run into a snag, any ideas or suggestions would be greatly appreciated.

Data validation will enable you to have a drop-down to select staff members, and another one to select courses.

VLOOKUP will return only a single result.

Filters are simple to implement, but you could generate the same results using a couple of formulae.

If you can find a template which suits your needs, then go for it.

I'm not really sure what your are looking for. Do you already have a sample Excel workbook that you can upload ? (See yellow banner at the top of the screen for details of how to do this).

Hope this helps.

Pete

I will try using filters. Thank you!

Crossposted here, sorry about that!

excelguru.ca/forums/showthread.php?10992-Best-method-to-create-training-log&p=45389#post45389