Im sure this is possible but I need to do it without using a pivot table.


I have a list of people that are trained in different areas.


I need XL to auto populate the people that are trained in a certain area when i select it from a drop down box.



Phones Dave Steve Alan Sarah Jeff Eric Shona
Post Steve Sally Sarah Eric Shona
Admin Dave Alan Sarah
Absence Eric


The list needs to appear next to it (if possible?)


Thanks