Vlookup with 2 conditions

John_Wh

Board Regular
Joined
Feb 26, 2013
Messages
61

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
Joined
Jun 12, 2014
Messages
33,775
Office Version
365
Platform
Windows
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
Joined
Feb 26, 2013
Messages
61
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:

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,775
Office Version
365
Platform
Windows
I'm sorry but I don't understand what you mean.
 

John_Wh

Board Regular
Joined
Feb 26, 2013
Messages
61
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
Joined
Jun 12, 2014
Messages
33,775
Office Version
365
Platform
Windows
Ok, in that case use
=INDEX($D$3:$D$2500,MATCH(G3&"|G",INDEX($A$3:$A$2500&"|"&$C$3:$C$2500,0),0))
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,775
Office Version
365
Platform
Windows
Glad to help & thanks for the feedback
 

Forum statistics

Threads
1,085,653
Messages
5,384,958
Members
401,928
Latest member
mohamed mansour

Some videos you may like

This Week's Hot Topics

Top