Hi all
Having issues figuring out how to draw data from a specific field for a player on a certain team. The problem is that players can be on multiple teams and each player on a team needs a minimum number of games player on that said team. So I need to reference the team ID and the player ID and if they match in the same row then I need to display the number of games played on the score sheet.
Sooo... Looking to do something like this
If A and B match in one row on Roster sheet print field C from the same row from Roster sheet in D on Scoresheet.
Currently I am using this
=IFERROR(VLOOKUP($C15,Player!$B$1:$O$846,2,0),"")
The Player sheet unfortunately is the players league wide stats so wouldn't help.
Thanks in advance
Having issues figuring out how to draw data from a specific field for a player on a certain team. The problem is that players can be on multiple teams and each player on a team needs a minimum number of games player on that said team. So I need to reference the team ID and the player ID and if they match in the same row then I need to display the number of games played on the score sheet.
Sooo... Looking to do something like this
If A and B match in one row on Roster sheet print field C from the same row from Roster sheet in D on Scoresheet.
Currently I am using this
=IFERROR(VLOOKUP($C15,Player!$B$1:$O$846,2,0),"")
The Player sheet unfortunately is the players league wide stats so wouldn't help.
Thanks in advance

Last edited: