Matching 3 columns and looking up values

[indygo]

hi experts!

I have two tables in two separate sheets. I need to Match and lookup outcome from Sheet 1 to Sheet 2.



[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Name1[/TD]
[TD]Name2[/TD]
[TD][/TD]
[TD]Outcome[/TD]
[TD]Outcome[/TD]
[/TR]
[TR]
[TD]21/09/17[/TD]
[TD]Adam[/TD]
[TD]Maria[/TD]
[TD][/TD]
[TD]W[/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD]20/09/17[/TD]
[TD]Donald[/TD]
[TD]Michelle[/TD]
[TD][/TD]
[TD]L[/TD]
[TD]W[/TD]
[/TR]
[TR]
[TD]19/09/17[/TD]
[TD]Kate[/TD]
[TD]Bob[/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

In different sheet I have similar table but without outcomes. I would like to match Date+name1+name2 and then copy outcome for each match.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Name1[/TD]
[TD]Name2[/TD]
[TD]Outcome[/TD]
[TD]Outcome[/TD]
[/TR]
[TR]
[TD]19/09/17[/TD]
[TD]Kate[/TD]
[TD]Bob[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21/09/17[/TD]
[TD]Adam[/TD]
[TD]Maria[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20/09/17[/TD]
[TD]Donald[/TD]
[TD]Michelle[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


If there is no score (n/a) it should leave cell empty. I know it's a combination of Index and Match and Vlookup but I got lost. Can we assume that both tables start in A1 in two sheets called Sheet1 and Sheet2 ? Thank you

 

[wideboydixon]

Multi VLOOKUP can help you here:

Book1
	A	B	C	D	E
1	Date	Name1	Name2	Outcome	Outcome
2	21/09/2017	Adam	Maria	W	L
3	20/09/2017	Donald	Michelle	L	W
4	19/09/2017	Kate	Bob	N/A	N/A
Sheet1

Book1
	A	B	C	D	E
1	Date	Name1	Name2	Outcome	Outcome
2	19/09/2017	Kate	Bob	N/A	N/A
3	21/09/2017	Adam	Maria	W	L
4	20/09/2017	Donald	Michelle	L	W
Sheet2

Cell Formulas
Range	Formula
D2	{=IFERROR(VLOOKUP($A2&$B2&$C2,CHOOSE({1,2},Sheet1!$A$2:$A$4&Sheet1!$B$2:$B$4&Sheet1!$C$2:$C$4,Sheet1!D$2:D$4),2,0),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

Copy formula in D2 across and down.

WBD

 

[indygo]

Thank you!

I appreciate