Hello Everyone!

I have an excel spreadsheet that has a column that lists project titles and 6 staff titles (project manager, admin asst, senior analyst). Many staff have different titles across projects. I want to be able to look a staff person name and see all of the projects and titles that they have held. Is this possible?

For example:

Stan Smith
---project manger for project A
---senior analyst for project D

Tracy Sue
---admin asst for project C
---asst analyst for project B

Please help...