Retrieve player names from another sheet having a database of duplicate team names.

Hey there,

Let me explain. This seems so simple, yet so consfusing (for me).

On sheet 1, in cell A1 I have 'Team 1'. Cell A1 is a dropdown list consisting of 10 teams.

In cell A3, I have 'Player names'. Under the cell A3 I want to list all the players of Team 1.

On another sheet, Column A has all teams in team numbers. Column B has Player names for the corresponding team number in column A.

For example: Col A = Team #s and Col B = Player Names.

Team #s --------------Player names

Team 1 ----------------Derek

Team 1-----------------James

Team 1-----------------Dean

Team 2------------------John

Team 2------------------Nolan

Team 3------------------X

Team 4-----------------Y

Team 4------------------Z

Team 4-------------------ZQ

So if I select Team 1 in the first sheet, I want it to list under 'Player names' - Derek, James, Dean.

Index is not working because it always gets stuck at Derek, it doesn't work below that.

Thanks for any help,

Any questions, just ask!

Check the below links for detailed instructions for achieving your expectation.

http://www.contextures.com/xlDataVal02.html

http://www.contextures.com/xlDataVal13.html

---

Sixthsense

Try Pivot Table.

If you don't have any issues in sharing your data then please attach it Or attach a sample workbook and the way you applied the Pivot. Because in my experience many persons fail in building pivot.

---

Sixthsense

Refer the Pivot1 and Pivot2 sheets.

---

Sixthsense

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.