Display cells based on value entered

[przemek1414]

Hello!

I am trying to create a sheet in my workbook that would display all the statistics of players on a certain team based on the team manually entered.

I attempted an index match, but that would only pull the first player from that team and ignore the remainder down the list. Is there a way to do this?

I would like to enter the team code e.g. CHI in cell A2 of sheet "check" and have the program display the 3 players on "CHI" team found on the "Summary" page and populate the corresponding data.

Any help is greatly appreciated!