Help Index and Match, Can I match 3 seperate criterias ?

[Vince1199s]

I have 3 worksheets
Points, Race, Results

I have used index and match but I have to change the first letter of the lookup array so that it picks up the next set of columns.
What I would really like is to match the 3 criterias, Race date, Rider Name and then Row 2 (Grid, )

Points

Excel 2010
	A	B	C	D
1	Place	Points	Grid Place	Points
2	1	25	1	5
3	2	20	2	4
4	3	16	3	3
5	4	13	4	2
Points

Cell Formulas
Range	Formula
A1	Place
A2	1
A3	2
A4	3
A5	4
A6	5
B1	Points
B2	25
B3	20
B4	16
B5	13
B6	11
C1	Grid Place
C2	1
C3	2
C4	3
C5	4
C6	5
D1	Points
D2	5
D3	4
D4	3
D5	2
D6	1

Race

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Name	Team/Bike	Price	28-Feb-16			13-Mar-16			20-Mar-16			03-Apr-16			10-Apr-16
2				Grid	Race 1	Race 2	Grid	Race 1	Race 2	Grid	Race 1	Race 2	Grid	Race 1	Race 2	Grid	Race 1	Race 2
3	S Byrne	Be Wiser PBM Ducati	£2,500,000	4	3	6	4	3	3	1	2	3	4	2	2	3	3	3
4	L Haslam	JG Speedfit Kawasaki	£2,300,000	3	2	1	5	2	2	5	3	Retired	1	1	1	1	1	1
5	J Ellison	JG Speedfit Kawasaki	£2,200,000	2	1	12	1	1	1		6	2	0	0	7	0	0	0
6	J Hopkins	ePayMe Yamaha	£2,200,000		9	7		13	19		8	4	0	0	4	0	4	6
7	M Laverty		£2,200,000		6	8		Retired	6	2	1	Retired	5	4	5	0	7	0
8	D Linfoot		£2,000,000		4	2		Retired	Retired		Retired	Retired	3	5	10	0	0	12
9	T Bridewell		£2,000,000		15	19		12	24		Retired	13	0	9	13	0	8	0
10	R Kiyonari		£1,900,000		10	17		11	15		10	7	0	10	12	0	0	13
11	S Easton		£1,800,000	5	11	3		6	5	3	4	1	0	7	6	2	2	2
Race

Cell Formulas
Range	Formula
A1	Name
A3	S Byrne
A4	L Haslam
A5	J Ellison
A6	J Hopkins
A7	M Laverty
A8	D Linfoot
A9	T Bridewell
A10	R Kiyonari
A11	S Easton
B1	Team/Bike
B3	Be Wiser PBM Ducati
B4	JG Speedfit Kawasaki
B5	JG Speedfit Kawasaki
B6	ePayMe Yamaha
C1	Price
C3	2500000
C4	2300000
C5	2200000
C6	2200000
C7	2200000
C8	2000000
C9	2000000
C10	1900000
C11	1800000
D1	42428
D2	Grid
D3	4
D4	3
D5	2
D11	5
G1	42442
G2	Grid
G3	4
G4	5
G5	1
J1	42449
J2	Grid
J3	1
J4	5
J7	2
J11	3
M1	42463
M2	Grid
M3	4
M4	1
M5	0
M6	0
M7	5
M8	3
M9	0
M10	0
M11	0
P1	42470
P2	Grid
P3	3
P4	1
P5	0
P6	0
P7	0
P8	0
P9	0
P10	0
P11	2
E2	Race 1
E3	3
E4	2
E5	1
E6	9
E7	6
E8	4
E9	15
E10	10
E11	11
F2	Race 2
F3	6
F4	1
F5	12
F6	7
F7	8
F8	2
F9	19
F10	17
F11	3
H2	Race 1
H3	3
H4	2
H5	1
H6	13
H7	Retired
H8	Retired
H9	12
H10	11
H11	6
I2	Race 2
I3	3
I4	2
I5	1
I6	19
I7	6
I8	Retired
I9	24
I10	15
I11	5
K2	Race 1
K3	2
K4	3
K5	6
K6	8
K7	1
K8	Retired
K9	Retired
K10	10
K11	4
L2	Race 2
L3	3
L4	Retired
L5	2
L6	4
L7	Retired
L8	Retired
L9	13
L10	7
L11	1
N2	Race 1
N3	2
N4	1
N5	0
N6	0
N7	4
N8	5
N9	9
N10	10
N11	7
O2	Race 2
O3	2
O4	1
O5	7
O6	4
O7	5
O8	10
O9	13
O10	12
O11	6
Q2	Race 1
Q3	3
Q4	1
Q5	0
Q6	4
Q7	7
Q8	0
Q9	8
Q10	0
Q11	2
R2	Race 2
R3	3
R4	1
R5	0
R6	6
R7	0
R8	12
R9	0
R10	13
R11	2

Results

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1		S Byrne			L Haslam			J Lorenzo		B Smith		J Rea			M vanderMark
2	Race Dates	Grid	Race 1	Race 2	Grid	Race 1	Race 2	Grid Position	Race 1	Grid Position	Race 1	Grid	Race 1	Race 2	Grid Position	Race 1	Race 2
3	28-Feb-16	4	3	6	3	2	1	4	3	0	10	1	1	2	2	3	3
4	13-Mar-16	4	3	3	5	2	2	4	3	0	11	1	1	1	0	11	15
5	20-Mar-16	1	2	3	5	3	Retired	1	2	0	10	4	1	2	2	2	1
6	03-Apr-16	4	2	2	1	1	1	4	2	0	10	2	1	1	4	2	2
7	10-Apr-16	3	3	3	1	1	1	3	3	0	0	3	1	1	4	Retired	Retired
Results

Cell Formulas
Range	Formula
B3	=INDEX(Race!$D$3:$CU$78,MATCH($B$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
B4	=INDEX(Race!$G$3:$CU$78,MATCH($B$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
B5	=INDEX(Race!$J$3:$CU$78,MATCH($B$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
B6	=INDEX(Race!$M$3:$CU$78,MATCH($B$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
B7	=INDEX(Race!$P$3:$CU$78,MATCH($B$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
C3	=INDEX(Race!$D$3:$CU$78,MATCH($B$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
C4	=INDEX(Race!$G$3:$CU$78,MATCH($B$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
C5	=INDEX(Race!$J$3:$CU$78,MATCH($B$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
C6	=INDEX(Race!$M$3:$CU$78,MATCH($B$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
C7	=INDEX(Race!$P$3:$CU$78,MATCH($B$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
D3	=INDEX(Race!$D$3:$CU$78,MATCH($B$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
D4	=INDEX(Race!$G$3:$CU$78,MATCH($B$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
D5	=INDEX(Race!$J$3:$CU$78,MATCH($B$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
D6	=INDEX(Race!$M$3:$CU$78,MATCH($B$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
D7	=INDEX(Race!$P$3:$CU$78,MATCH($B$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
E3	=INDEX(Race!$D$3:$CU$78,MATCH($E$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
E4	=INDEX(Race!$G$3:$CU$78,MATCH($E$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
E5	=INDEX(Race!$J$3:$CU$78,MATCH($E$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
E6	=INDEX(Race!$M$3:$CU$78,MATCH($E$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
E7	=INDEX(Race!$P$3:$CU$78,MATCH($E$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
F3	=INDEX(Race!$D$3:$CU$78,MATCH($E$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
F4	=INDEX(Race!$G$3:$CU$78,MATCH($E$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
F5	=INDEX(Race!$J$3:$CU$78,MATCH($E$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
F6	=INDEX(Race!$M$3:$CU$78,MATCH($E$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
F7	=INDEX(Race!$P$3:$CU$78,MATCH($E$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
G3	=INDEX(Race!$D$3:$CU$78,MATCH($E$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
G4	=INDEX(Race!$G$3:$CU$78,MATCH($E$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
G5	=INDEX(Race!$J$3:$CU$78,MATCH($E$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
G6	=INDEX(Race!$M$3:$CU$78,MATCH($E$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
G7	=INDEX(Race!$P$3:$CU$78,MATCH($E$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
H3	=INDEX(Race!$D$3:$CU$78,MATCH($H$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
H4	=INDEX(Race!$G$3:$CU$78,MATCH($H$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
H5	=INDEX(Race!$J$3:$CU$78,MATCH($H$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
H6	=INDEX(Race!$M$3:$CU$78,MATCH($H$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
H7	=INDEX(Race!$P$3:$CU$78,MATCH($H$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
I3	=INDEX(Race!$D$3:$CU$78,MATCH($H$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
I4	=INDEX(Race!$G$3:$CU$78,MATCH($H$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
I5	=INDEX(Race!$J$3:$CU$78,MATCH($H$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
I6	=INDEX(Race!$M$3:$CU$78,MATCH($H$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
I7	=INDEX(Race!$P$3:$CU$78,MATCH($H$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
J3	=INDEX(Race!$D$3:$CU$78,MATCH($J$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
J4	=INDEX(Race!$G$3:$CU$78,MATCH($J$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
J5	=INDEX(Race!$J$3:$CU$78,MATCH($J$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
J6	=INDEX(Race!$M$3:$CU$78,MATCH($J$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
J7	=INDEX(Race!$P$3:$CU$78,MATCH($J$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
K3	=INDEX(Race!$D$3:$CU$78,MATCH($J$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
K4	=INDEX(Race!$G$3:$CU$78,MATCH($J$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
K5	=INDEX(Race!$J$3:$CU$78,MATCH($J$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
K6	=INDEX(Race!$M$3:$CU$78,MATCH($J$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
K7	=INDEX(Race!$P$3:$CU$78,MATCH($J$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
L3	=INDEX(Race!$D$3:$CU$78,MATCH($L$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
L4	=INDEX(Race!$G$3:$CU$78,MATCH($L$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
L5	=INDEX(Race!$J$3:$CU$78,MATCH($L$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
L6	=INDEX(Race!$M$3:$CU$78,MATCH($L$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
L7	=INDEX(Race!$P$3:$CU$78,MATCH($L$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
M3	=INDEX(Race!$D$3:$CU$78,MATCH($L$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
M4	=INDEX(Race!$G$3:$CU$78,MATCH($L$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
M5	=INDEX(Race!$J$3:$CU$78,MATCH($L$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
M6	=INDEX(Race!$M$3:$CU$78,MATCH($L$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
M7	=INDEX(Race!$P$3:$CU$78,MATCH($L$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
N3	=INDEX(Race!$D$3:$CU$78,MATCH($L$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
N4	=INDEX(Race!$G$3:$CU$78,MATCH($L$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
N5	=INDEX(Race!$J$3:$CU$78,MATCH($L$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
N6	=INDEX(Race!$M$3:$CU$78,MATCH($L$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
N7	=INDEX(Race!$P$3:$CU$78,MATCH($L$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
O3	=INDEX(Race!$D$3:$CU$78,MATCH($O$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
O4	=INDEX(Race!$G$3:$CU$78,MATCH($O$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
O5	=INDEX(Race!$J$3:$CU$78,MATCH($O$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
O6	=INDEX(Race!$M$3:$CU$78,MATCH($O$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
O7	=INDEX(Race!$P$3:$CU$78,MATCH($O$1,Race!$A$3:$A$78,0),MATCH($B$2,Race!$D$2:$F$2,0))
P3	=INDEX(Race!$D$3:$CU$78,MATCH($O$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
P4	=INDEX(Race!$G$3:$CU$78,MATCH($O$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
P5	=INDEX(Race!$J$3:$CU$78,MATCH($O$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
P6	=INDEX(Race!$M$3:$CU$78,MATCH($O$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
P7	=INDEX(Race!$P$3:$CU$78,MATCH($O$1,Race!$A$3:$A$78,0),MATCH($C$2,Race!$D$2:$F$2,0))
Q3	=INDEX(Race!$D$3:$CU$78,MATCH($O$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
Q4	=INDEX(Race!$G$3:$CU$78,MATCH($O$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
Q5	=INDEX(Race!$J$3:$CU$78,MATCH($O$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
Q6	=INDEX(Race!$M$3:$CU$78,MATCH($O$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))
Q7	=INDEX(Race!$P$3:$CU$78,MATCH($O$1,Race!$A$3:$A$78,0),MATCH($D$2,Race!$D$2:$F$2,0))

 

[Vince1199s]

Would it be possible to match the 3 criteria's, Race date, Rider Name and Grid or Race 1 , Race 2 but on top of this if it could then look up its respective value in the Points worksheet and populate the cell with the points awarded for that placing rather than the place value.