Vlookup with 2 conditions

John_Wh

Board Regular

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

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

John_Wh

Board Regular
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
 
Last edited:

John_Wh

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

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

Fluff

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

Some videos you may like

This Week's Hot Topics

Top