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.

Date	Name1	Name2		Outcome	Outcome
21/09/17	Adam	Maria		W	L
20/09/17	Donald	Michelle		L	W
19/09/17	Kate	Bob		N/A	N/A

<tbody>
</tbody>

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.

Date	Name1	Name2	Outcome	Outcome
19/09/17	Kate	Bob
21/09/17	Adam	Maria
20/09/17	Donald	Michelle

<tbody>
</tbody>

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