Vlookup with 2 conditions

[John_Whin]

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

 

[Fluff]

How about
=INDEX($D$3:$D$13,MATCH(G3&"|G",INDEX($A$3:$A$13&"|"&$C$3:$C$13,0),0))

 

[John_Whin]

Hey again Fluff, can you make it simple for me, instead of the example make the array $A$3:$D$2500. The game # and the return cell for the result is the same.

Thanks

 

[Fluff]

I'm sorry but I don't understand what you mean.

 

[John_Whin]

In the image in the first post the table is from $A$3:$D$12

The actual table is $A$3:$D$2500

 

[Fluff]

Ok, in that case use
=INDEX($D$3:$D$2500,MATCH(G3&"|G",INDEX($A$3:$A$2500&"|"&$C$3:$C$2500,0),0))

 

[John_Whin]

Thanks again, you've been helpful several times over the years!

 

[Fluff]

Glad to help & thanks for the feedback