I'm creating a workbook to track stats for a hockey team. On the first sheet I have all of the teams listed along with their players. Each team is a table and the table name is the name of the team
(https://i.stack.imgur.com/24pOw.png)
On the second sheet when I enter the team name I want a formula to bring over all of the players for that team based on the team name I entered
(https://i.stack.imgur.com/dEr65.png)
This is the formula I'm using for I6 (https://i.stack.imgur.com/pQq6l.png)
I've tried using INDIRECT, which worked for the INDEX but not for MATCH
Thanks in advance for any help you can provide
