Beginning in Column H3, based on the value in column G3, I want to return the starting goalie for the game.
So for game 1 I want to return "Pekka Rinne", Game 2 "Jusse Saros" from the array $A$3:$D$12
The linked picture of the example sheet, the eventual array will be 2000 rows.
https://imgur.com/a/yOdTpT9
thanks