How to match the data in different table

[kelvin0403]

Hi everyone,

I have a set of data as Table 1. I would like to have a formula to link the Target capacity in Table 1 to Table 2.
Example, in Table 2, date 1, I need the result to return as 68.25 when the machine (G1) when it is running product 2T. Same goes to others machines. Thank you..

Table 1
[TABLE="width: 448"]
<tbody>[TR]
[TD="class: xl73, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl76, width: 192, bgcolor: yellow, colspan: 3"]Commited Capacity
[/TD]
[TD="class: xl77, width: 192, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , colspan: 3"]Target
[/TD]
[/TR]
[TR]
[TD="class: xl74, bgcolor: transparent"]Machine
[/TD]
[TD="class: xl74, bgcolor: transparent"]1T
[/TD]
[TD="class: xl74, bgcolor: transparent"]2T
[/TD]
[TD="class: xl74, bgcolor: transparent"]2TS
[/TD]
[TD="class: xl74, bgcolor: transparent"]1T
[/TD]
[TD="class: xl74, bgcolor: transparent"]2T
[/TD]
[TD="class: xl74, bgcolor: transparent"]2TS
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]G1
[/TD]
[TD="class: xl72, bgcolor: transparent"]55
[/TD]
[TD="class: xl72, bgcolor: transparent"]65
[/TD]
[TD="class: xl72, bgcolor: transparent"]90
[/TD]
[TD="class: xl72, bgcolor: transparent"]57.2
[/TD]
[TD="class: xl72, bgcolor: transparent"]68.25
[/TD]
[TD="class: xl72, bgcolor: transparent"]94.5
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]G2
[/TD]
[TD="class: xl72, bgcolor: transparent"]55
[/TD]
[TD="class: xl72, bgcolor: transparent"]65
[/TD]
[TD="class: xl75, bgcolor: #D9D9D9"][/TD]
[TD="class: xl72, bgcolor: transparent"]57.2
[/TD]
[TD="class: xl72, bgcolor: transparent"]68.25
[/TD]
[TD="class: xl75, bgcolor: #D9D9D9"][/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]G3
[/TD]
[TD="class: xl72, bgcolor: transparent"]55
[/TD]
[TD="class: xl72, bgcolor: transparent"]65
[/TD]
[TD="class: xl75, bgcolor: #D9D9D9"][/TD]
[TD="class: xl72, bgcolor: transparent"]57.2
[/TD]
[TD="class: xl72, bgcolor: transparent"]68.25
[/TD]
[TD="class: xl75, bgcolor: #D9D9D9"][/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]G4
[/TD]
[TD="class: xl72, bgcolor: transparent"]55
[/TD]
[TD="class: xl72, bgcolor: transparent"]65
[/TD]
[TD="class: xl75, bgcolor: #D9D9D9"][/TD]
[TD="class: xl72, bgcolor: transparent"]57.75
[/TD]
[TD="class: xl72, bgcolor: transparent"]68.25
[/TD]
[TD="class: xl75, bgcolor: #D9D9D9"][/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]G5
[/TD]
[TD="class: xl72, bgcolor: transparent"]50
[/TD]
[TD="class: xl72, bgcolor: transparent"]60
[/TD]
[TD="class: xl75, bgcolor: #D9D9D9"][/TD]
[TD="class: xl72, bgcolor: transparent"]52.5
[/TD]
[TD="class: xl72, bgcolor: transparent"]63
[/TD]
[TD="class: xl75, bgcolor: #D9D9D9"][/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]G6
[/TD]
[TD="class: xl72, bgcolor: transparent"]55
[/TD]
[TD="class: xl72, bgcolor: transparent"]65
[/TD]
[TD="class: xl75, bgcolor: #D9D9D9"][/TD]
[TD="class: xl72, bgcolor: transparent"]57.2
[/TD]
[TD="class: xl72, bgcolor: transparent"]68.25
[/TD]
[TD="class: xl75, bgcolor: #D9D9D9"][/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]G7
[/TD]
[TD="class: xl72, bgcolor: transparent"]55
[/TD]
[TD="class: xl72, bgcolor: transparent"]70
[/TD]
[TD="class: xl75, bgcolor: #D9D9D9"][/TD]
[TD="class: xl72, bgcolor: transparent"]57.2
[/TD]
[TD="class: xl72, bgcolor: transparent"]73.5
[/TD]
[TD="class: xl75, bgcolor: #D9D9D9"][/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]G8
[/TD]
[TD="class: xl72, bgcolor: transparent"]55
[/TD]
[TD="class: xl72, bgcolor: transparent"]70
[/TD]
[TD="class: xl75, bgcolor: #D9D9D9"][/TD]
[TD="class: xl72, bgcolor: transparent"]57.2
[/TD]
[TD="class: xl72, bgcolor: transparent"]73.5
[/TD]
[TD="class: xl75, bgcolor: #D9D9D9"][/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Total
[/TD]
[TD="class: xl72, bgcolor: transparent"]435
[/TD]
[TD="class: xl72, bgcolor: transparent"]525
[/TD]
[TD="class: xl72, bgcolor: transparent"]90
[/TD]
[TD="class: xl72, bgcolor: transparent"]453.45
[/TD]
[TD="class: xl72, bgcolor: transparent"]551.25
[/TD]
[TD="class: xl72, bgcolor: transparent"]94.5
[/TD]
[/TR]
</tbody>[/TABLE]

Table 2

[TABLE="class: grid, width: 616"]
<tbody>[TR]
[TD]Date[/TD]
[TD]G1[/TD]
[TD]G2[/TD]
[TD]G3[/TD]
[TD]G4[/TD]
[TD]G5[/TD]
[TD]G6[/TD]
[TD]G7[/TD]
[TD]G8[/TD]
[TD]Date[/TD]
[TD]G1[/TD]
[TD]G2[/TD]
[TD]G3[/TD]
[TD]G4[/TD]
[TD]G5[/TD]
[TD]G6[/TD]
[TD]G7[/TD]
[TD]G8[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]1T[/TD]
[TD]1T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]1[/TD]
[TD]68.25[/TD]
[TD]68.25[/TD]
[TD]68.25[/TD]
[TD]57.75[/TD]
[TD]63.00[/TD]
[TD]68.25[/TD]
[TD]73.50[/TD]
[TD]73.50[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]1T[/TD]
[TD]1T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]1T[/TD]
[TD]1T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]1T[/TD]
[TD]1T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]1T[/TD]
[TD]1T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]1T[/TD]
[TD]1T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]1T[/TD]
[TD]1T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]1T[/TD]
[TD]1T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]1T[/TD]
[TD]1T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]9[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]2TS[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]1T[/TD]
[TD]1T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]2T[/TD]
[TD]10[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col span="8"><col><col span="8"></colgroup>[/TABLE]

 

[Scott T]

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1		Commited Capacity			Target
2	Machine	1T	2T	2TS	1T	2T	2TS
3	G1	55	65	90	57.2	68.25	94.5
4	G2	55	65		57.2	68.25
5	G3	55	65		57.2	68.25
6	G4	55	65		57.75	68.25
7	G5	50	60		52.5	63
8	G6	55	65		57.2	68.25
9	G7	55	70		57.2	73.5
10	G8	55	70		57.2	73.5
11	Total	435	525	90	453.45	551.25	94.5
12
13											68.25	68.25	68.25	57.75	63	68.25	73.5	73.5
14
15	Date	G1	G2	G3	G4	G5	G6	G7	G8	Date	G1	G2	G3	G4	G5	G6	G7	G8
16	1	2T	2T	2T	1T	1T	2T	2T	2T	1	68.25	68.25	68.25	57.75	52.5	68.25	73.5	73.5
17	2	2T	2T	2T	1T	1T	2T	2T	2T	2	68.25	68.25	68.25	57.75	52.5	68.25	73.5	73.5
18	3	2T	2T	2T	1T	1T	2T	2T	2T	3	68.25	68.25	68.25	57.75	52.5	68.25	73.5	73.5
19	4	2T	2T	2T	1T	1T	2T	2T	2T	4	68.25	68.25	68.25	57.75	52.5	68.25	73.5	73.5
20	5	2T	2T	2T	1T	1T	2T	2T	2T	5	68.25	68.25	68.25	57.75	52.5	68.25	73.5	73.5
21	6	2T	2T	2T	1T	1T	2T	2T	2T	6	68.25	68.25	68.25	57.75	52.5	68.25	73.5	73.5
22	7	2T	2T	2T	1T	1T	2T	2T	2T	7	68.25	68.25	68.25	57.75	52.5	68.25	73.5	73.5
23	8	2T	2T	2T	1T	1T	2T	2T	2T	8	68.25	68.25	68.25	57.75	52.5	68.25	73.5	73.5
24	9	2T	2T	2T	1T	1T	2T	2T	2T	9	68.25	68.25	68.25	57.75	52.5	68.25	73.5	73.5
25	10	2TS	2T	2T	1T	1T	2T	2T	2T	10	94.5	68.25	68.25	57.75	52.5	68.25	73.5	73.5
Sheet5

Cell Formulas
Range	Formula
K16	=INDEX($E$3:$G$10,MATCH(B$15,$A$3:$A$10,0),MATCH(B16,$E$2:$G$2,0))
K17	=INDEX($E$3:$G$10,MATCH(B$15,$A$3:$A$10,0),MATCH(B17,$E$2:$G$2,0))
K18	=INDEX($E$3:$G$10,MATCH(B$15,$A$3:$A$10,0),MATCH(B18,$E$2:$G$2,0))
K19	=INDEX($E$3:$G$10,MATCH(B$15,$A$3:$A$10,0),MATCH(B19,$E$2:$G$2,0))
K20	=INDEX($E$3:$G$10,MATCH(B$15,$A$3:$A$10,0),MATCH(B20,$E$2:$G$2,0))
K21	=INDEX($E$3:$G$10,MATCH(B$15,$A$3:$A$10,0),MATCH(B21,$E$2:$G$2,0))
K22	=INDEX($E$3:$G$10,MATCH(B$15,$A$3:$A$10,0),MATCH(B22,$E$2:$G$2,0))
K23	=INDEX($E$3:$G$10,MATCH(B$15,$A$3:$A$10,0),MATCH(B23,$E$2:$G$2,0))
K24	=INDEX($E$3:$G$10,MATCH(B$15,$A$3:$A$10,0),MATCH(B24,$E$2:$G$2,0))
K25	=INDEX($E$3:$G$10,MATCH(B$15,$A$3:$A$10,0),MATCH(B25,$E$2:$G$2,0))
L16	=INDEX($E$3:$G$10,MATCH(C$15,$A$3:$A$10,0),MATCH(C16,$E$2:$G$2,0))
L17	=INDEX($E$3:$G$10,MATCH(C$15,$A$3:$A$10,0),MATCH(C17,$E$2:$G$2,0))
L18	=INDEX($E$3:$G$10,MATCH(C$15,$A$3:$A$10,0),MATCH(C18,$E$2:$G$2,0))
L19	=INDEX($E$3:$G$10,MATCH(C$15,$A$3:$A$10,0),MATCH(C19,$E$2:$G$2,0))
L20	=INDEX($E$3:$G$10,MATCH(C$15,$A$3:$A$10,0),MATCH(C20,$E$2:$G$2,0))
L21	=INDEX($E$3:$G$10,MATCH(C$15,$A$3:$A$10,0),MATCH(C21,$E$2:$G$2,0))
L22	=INDEX($E$3:$G$10,MATCH(C$15,$A$3:$A$10,0),MATCH(C22,$E$2:$G$2,0))
L23	=INDEX($E$3:$G$10,MATCH(C$15,$A$3:$A$10,0),MATCH(C23,$E$2:$G$2,0))
L24	=INDEX($E$3:$G$10,MATCH(C$15,$A$3:$A$10,0),MATCH(C24,$E$2:$G$2,0))
L25	=INDEX($E$3:$G$10,MATCH(C$15,$A$3:$A$10,0),MATCH(C25,$E$2:$G$2,0))
M16	=INDEX($E$3:$G$10,MATCH(D$15,$A$3:$A$10,0),MATCH(D16,$E$2:$G$2,0))
M17	=INDEX($E$3:$G$10,MATCH(D$15,$A$3:$A$10,0),MATCH(D17,$E$2:$G$2,0))
M18	=INDEX($E$3:$G$10,MATCH(D$15,$A$3:$A$10,0),MATCH(D18,$E$2:$G$2,0))
M19	=INDEX($E$3:$G$10,MATCH(D$15,$A$3:$A$10,0),MATCH(D19,$E$2:$G$2,0))
M20	=INDEX($E$3:$G$10,MATCH(D$15,$A$3:$A$10,0),MATCH(D20,$E$2:$G$2,0))
M21	=INDEX($E$3:$G$10,MATCH(D$15,$A$3:$A$10,0),MATCH(D21,$E$2:$G$2,0))
M22	=INDEX($E$3:$G$10,MATCH(D$15,$A$3:$A$10,0),MATCH(D22,$E$2:$G$2,0))
M23	=INDEX($E$3:$G$10,MATCH(D$15,$A$3:$A$10,0),MATCH(D23,$E$2:$G$2,0))
M24	=INDEX($E$3:$G$10,MATCH(D$15,$A$3:$A$10,0),MATCH(D24,$E$2:$G$2,0))
M25	=INDEX($E$3:$G$10,MATCH(D$15,$A$3:$A$10,0),MATCH(D25,$E$2:$G$2,0))
N16	=INDEX($E$3:$G$10,MATCH(E$15,$A$3:$A$10,0),MATCH(E16,$E$2:$G$2,0))
N17	=INDEX($E$3:$G$10,MATCH(E$15,$A$3:$A$10,0),MATCH(E17,$E$2:$G$2,0))
N18	=INDEX($E$3:$G$10,MATCH(E$15,$A$3:$A$10,0),MATCH(E18,$E$2:$G$2,0))
N19	=INDEX($E$3:$G$10,MATCH(E$15,$A$3:$A$10,0),MATCH(E19,$E$2:$G$2,0))
N20	=INDEX($E$3:$G$10,MATCH(E$15,$A$3:$A$10,0),MATCH(E20,$E$2:$G$2,0))
N21	=INDEX($E$3:$G$10,MATCH(E$15,$A$3:$A$10,0),MATCH(E21,$E$2:$G$2,0))
N22	=INDEX($E$3:$G$10,MATCH(E$15,$A$3:$A$10,0),MATCH(E22,$E$2:$G$2,0))
N23	=INDEX($E$3:$G$10,MATCH(E$15,$A$3:$A$10,0),MATCH(E23,$E$2:$G$2,0))
N24	=INDEX($E$3:$G$10,MATCH(E$15,$A$3:$A$10,0),MATCH(E24,$E$2:$G$2,0))
N25	=INDEX($E$3:$G$10,MATCH(E$15,$A$3:$A$10,0),MATCH(E25,$E$2:$G$2,0))
O16	=INDEX($E$3:$G$10,MATCH(F$15,$A$3:$A$10,0),MATCH(F16,$E$2:$G$2,0))
O17	=INDEX($E$3:$G$10,MATCH(F$15,$A$3:$A$10,0),MATCH(F17,$E$2:$G$2,0))
O18	=INDEX($E$3:$G$10,MATCH(F$15,$A$3:$A$10,0),MATCH(F18,$E$2:$G$2,0))
O19	=INDEX($E$3:$G$10,MATCH(F$15,$A$3:$A$10,0),MATCH(F19,$E$2:$G$2,0))
O20	=INDEX($E$3:$G$10,MATCH(F$15,$A$3:$A$10,0),MATCH(F20,$E$2:$G$2,0))
O21	=INDEX($E$3:$G$10,MATCH(F$15,$A$3:$A$10,0),MATCH(F21,$E$2:$G$2,0))
O22	=INDEX($E$3:$G$10,MATCH(F$15,$A$3:$A$10,0),MATCH(F22,$E$2:$G$2,0))
O23	=INDEX($E$3:$G$10,MATCH(F$15,$A$3:$A$10,0),MATCH(F23,$E$2:$G$2,0))
O24	=INDEX($E$3:$G$10,MATCH(F$15,$A$3:$A$10,0),MATCH(F24,$E$2:$G$2,0))
O25	=INDEX($E$3:$G$10,MATCH(F$15,$A$3:$A$10,0),MATCH(F25,$E$2:$G$2,0))
P16	=INDEX($E$3:$G$10,MATCH(G$15,$A$3:$A$10,0),MATCH(G16,$E$2:$G$2,0))
P17	=INDEX($E$3:$G$10,MATCH(G$15,$A$3:$A$10,0),MATCH(G17,$E$2:$G$2,0))
P18	=INDEX($E$3:$G$10,MATCH(G$15,$A$3:$A$10,0),MATCH(G18,$E$2:$G$2,0))
P19	=INDEX($E$3:$G$10,MATCH(G$15,$A$3:$A$10,0),MATCH(G19,$E$2:$G$2,0))
P20	=INDEX($E$3:$G$10,MATCH(G$15,$A$3:$A$10,0),MATCH(G20,$E$2:$G$2,0))
P21	=INDEX($E$3:$G$10,MATCH(G$15,$A$3:$A$10,0),MATCH(G21,$E$2:$G$2,0))
P22	=INDEX($E$3:$G$10,MATCH(G$15,$A$3:$A$10,0),MATCH(G22,$E$2:$G$2,0))
P23	=INDEX($E$3:$G$10,MATCH(G$15,$A$3:$A$10,0),MATCH(G23,$E$2:$G$2,0))
P24	=INDEX($E$3:$G$10,MATCH(G$15,$A$3:$A$10,0),MATCH(G24,$E$2:$G$2,0))
P25	=INDEX($E$3:$G$10,MATCH(G$15,$A$3:$A$10,0),MATCH(G25,$E$2:$G$2,0))
Q16	=INDEX($E$3:$G$10,MATCH(H$15,$A$3:$A$10,0),MATCH(H16,$E$2:$G$2,0))
Q17	=INDEX($E$3:$G$10,MATCH(H$15,$A$3:$A$10,0),MATCH(H17,$E$2:$G$2,0))
Q18	=INDEX($E$3:$G$10,MATCH(H$15,$A$3:$A$10,0),MATCH(H18,$E$2:$G$2,0))
Q19	=INDEX($E$3:$G$10,MATCH(H$15,$A$3:$A$10,0),MATCH(H19,$E$2:$G$2,0))
Q20	=INDEX($E$3:$G$10,MATCH(H$15,$A$3:$A$10,0),MATCH(H20,$E$2:$G$2,0))
Q21	=INDEX($E$3:$G$10,MATCH(H$15,$A$3:$A$10,0),MATCH(H21,$E$2:$G$2,0))
Q22	=INDEX($E$3:$G$10,MATCH(H$15,$A$3:$A$10,0),MATCH(H22,$E$2:$G$2,0))
Q23	=INDEX($E$3:$G$10,MATCH(H$15,$A$3:$A$10,0),MATCH(H23,$E$2:$G$2,0))
Q24	=INDEX($E$3:$G$10,MATCH(H$15,$A$3:$A$10,0),MATCH(H24,$E$2:$G$2,0))
Q25	=INDEX($E$3:$G$10,MATCH(H$15,$A$3:$A$10,0),MATCH(H25,$E$2:$G$2,0))
R16	=INDEX($E$3:$G$10,MATCH(I$15,$A$3:$A$10,0),MATCH(I16,$E$2:$G$2,0))
R17	=INDEX($E$3:$G$10,MATCH(I$15,$A$3:$A$10,0),MATCH(I17,$E$2:$G$2,0))
R18	=INDEX($E$3:$G$10,MATCH(I$15,$A$3:$A$10,0),MATCH(I18,$E$2:$G$2,0))
R19	=INDEX($E$3:$G$10,MATCH(I$15,$A$3:$A$10,0),MATCH(I19,$E$2:$G$2,0))
R20	=INDEX($E$3:$G$10,MATCH(I$15,$A$3:$A$10,0),MATCH(I20,$E$2:$G$2,0))
R21	=INDEX($E$3:$G$10,MATCH(I$15,$A$3:$A$10,0),MATCH(I21,$E$2:$G$2,0))
R22	=INDEX($E$3:$G$10,MATCH(I$15,$A$3:$A$10,0),MATCH(I22,$E$2:$G$2,0))
R23	=INDEX($E$3:$G$10,MATCH(I$15,$A$3:$A$10,0),MATCH(I23,$E$2:$G$2,0))
R24	=INDEX($E$3:$G$10,MATCH(I$15,$A$3:$A$10,0),MATCH(I24,$E$2:$G$2,0))
R25	=INDEX($E$3:$G$10,MATCH(I$15,$A$3:$A$10,0),MATCH(I25,$E$2:$G$2,0))

 

[kelvin0403]

Thanks Scott, this is awesome!

 

[Scott T]

You are welcome.