ested IF wont work as I need 18

P

Paul

Hi, I have a worksheet that I want to place some drop-down lists. I
have 18 teams with different members. When a user selects team 1 or 2
etc in col1, then I would like Col2 cells to show only those team
members that belong to that team.

I have done these previously with nested Ifs, but this only works for
7 teams, this time I have 18 Teams. Please can someone help me.

Thanks

Col1 Col2
Team1 Paul
John
Steve
Team2 Derek
Phil
Rich
Team3 Carol
Tony
Julie
Etc Etc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top