Index & Match

[Geger]

Hello - can you help me with index & match formula. I've tried many times but I can't get it

I have a large data set that I need to update week as week go by so I need to do an index/ match to return information on another workbook automatically as I refresh the weekly dates.

TYPE

Size

9-Jul

16-Jul

23-Jul

30-Jul

6-Aug

13-Aug

20-Aug

27-Aug

3-Sep

10-Sep

17-Sep

24-Sep

1-Oct

8-Oct

15-Oct

BLUE

1

BLUE

4.5

BLUE

1.5

565

YELLOW

1

143

YELLOW

4.5

YELLOW

1.5

234

<colgroup><col width="64" span="17" style="width:48pt"> </colgroup><tbody>
</tbody>

TYPE	Size	9-Jul	16-Jul	23-Jul	30-Jul	6-Aug	13-Aug	20-Aug	27-Aug	3-Sep	10-Sep	17-Sep	24-Sep	1-Oct	8-Oct	15-Oct	22-Oct	29-Oct	5-Nov
BLUE	1	0	0	0	0	0	0	0	0	5000	1456	5656	5646	124	11292	8974	890	1456	8187
GREEN	1	0	0	0	0	0	0	0	0	1836	587	2348	168	672	336	927	2556	7049	244
RED	1	0	0	0	0	0	0	0	0	199	153	612	144	576	288	794	2191	6042	209
YELLOW	1	0	0	143	0	0	0	0	0	1500	1359	5436	388	1553	777	2142	5907	16292	563
YELLOW	4.5	0	0	0	0	0	0	0	0	1405	164	656	47	187	94	258	713	1966	68
RED	4.5	0	0	0	0	0	0	0	0	2000	546	2184	156	624	312	860	2373	6545	226
BLUE	4.5	0	0	0	0	0	0	0	0	675	597	2388	171	684	342	943	2601	7175	248
GREEN	4.5	0	0	0	0	0	0	0	0	130	1122	4488	321	1282	641	1768	4877	13450	465
BLUE	1.5	0	565	0	0	0	0	0	0	400	653	2612	187	748	374	1031	2845	7846	271
YELLOW	1.5	0	234	0	0	0	0	0	0	14	51	204	15	60	30	83	228	629	22
GREEN	1.5	0	0	0	0	0	0	0	0	846	4987	19948	1425	5700	2850	7860	2164	1435	2066
RED	1.5	0	0	0	0	0	0	0	0	19	785	3140	224	896	448	1236	3408	9399	325

<colgroup><col><col span="19"></colgroup><tbody>
</tbody>

 

[yky]

Re: Help with Index & Match... not working at all!

In column U next to the second table (in my case, A11:T23), enter "=A11&B11". Copy it down to U23. This is a help column. If you don't want to see it, either hide it or set it at an obscure place so you won't see it.

In D4 (16-Jul, Blue, 1.5), enter the formula "=INDEX(D$12:D$23,MATCH($A4&$B4,$U$12:$U$23,0),MATCH(D$1,D$11:$T$11,0))". Copy and paste it to the rest of the table 1.

 

[Muhammad_Usman]

Re: Help with Index & Match... not working at all!

Welcome To Board Geger!
Try following Formula to solve your problem. Copy and Past Formula in C11, Drag down and left ward according to your need. And reply me is it work for you.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	TYPE	Size	9-Jul	16-Jul	23-Jul	30-Jul	6-Aug	13-Aug	20-Aug	27-Aug	3-Sep	10-Sep	17-Sep	24-Sep	1-Oct	8-Oct	15-Oct
2	Blue	1	565
3	BLUE	4.5					565
4	BLUE	1.5		565
5	BLUE	1.5					143
6	YELLOW	1			143
7	YELLOW	4.5					234
8	YELLOW	1.5		234
9
10	TYPE	Size	9-Jul	16-Jul	23-Jul	30-Jul	6-Aug	13-Aug	20-Aug	27-Aug	3-Sep	10-Sep	17-Sep	24-Sep	1-Oct	8-Oct	15-Oct
11	Blue	1	565	0	0	0	0	0	0	0	0	0	0	0	0	0	0
12	Green	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
13	Red	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
14	Yellow	1	0	0	143	0	0	0	0	0	0	0	0	0	0	0	0
15	Yellow	4.5	0	0	0	0	234	0	0	0	0	0	0	0	0	0	0
16	Red	4.5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
17	Blue	4.5	0	0	0	0	565	0	0	0	0	0	0	0	0	0	0
18	Green	4.5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
19	Blue	1.5	0	565	0	0	143	0	0	0	0	0	0	0	0	0	0
20	Green	1.5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
21	Red	1.5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
22	Yellow	1.5	0	234	0	0	0	0	0	0	0	0	0	0	0	0	0
Sheet3

Cell Formulas
Range	Formula
C11	=(SUMPRODUCT(($A$2:$A$8=$A11)*($B$2:$B$8=$B11)*(C$2:C$8)))
C12	=SUMPRODUCT(($A$2:$A$8=$A12)*($B$2:$B$8=$B12)*(C$2:C$8))
C13	=SUMPRODUCT(($A$2:$A$8=$A13)*($B$2:$B$8=$B13)*(C$2:C$8))
C14	=SUMPRODUCT(($A$2:$A$8=$A14)*($B$2:$B$8=$B14)*(C$2:C$8))
C15	=SUMPRODUCT(($A$2:$A$8=$A15)*($B$2:$B$8=$B15)*(C$2:C$8))
C16	=SUMPRODUCT(($A$2:$A$8=$A16)*($B$2:$B$8=$B16)*(C$2:C$8))
C17	=SUMPRODUCT(($A$2:$A$8=$A17)*($B$2:$B$8=$B17)*(C$2:C$8))
C18	=SUMPRODUCT(($A$2:$A$8=$A18)*($B$2:$B$8=$B18)*(C$2:C$8))
C19	=SUMPRODUCT(($A$2:$A$8=$A19)*($B$2:$B$8=$B19)*(C$2:C$8))
C20	=SUMPRODUCT(($A$2:$A$8=$A20)*($B$2:$B$8=$B20)*(C$2:C$8))
C21	=SUMPRODUCT(($A$2:$A$8=$A21)*($B$2:$B$8=$B21)*(C$2:C$8))
C22	=SUMPRODUCT(($A$2:$A$8=$A22)*($B$2:$B$8=$B22)*(C$2:C$8))
D11	=SUMPRODUCT(($A$2:$A$8=$A11)*($B$2:$B$8=$B11)*(D$2:D$8))
D12	=SUMPRODUCT(($A$2:$A$8=$A12)*($B$2:$B$8=$B12)*(D$2:D$8))
D13	=SUMPRODUCT(($A$2:$A$8=$A13)*($B$2:$B$8=$B13)*(D$2:D$8))
D14	=SUMPRODUCT(($A$2:$A$8=$A14)*($B$2:$B$8=$B14)*(D$2:D$8))
D15	=SUMPRODUCT(($A$2:$A$8=$A15)*($B$2:$B$8=$B15)*(D$2:D$8))
D16	=SUMPRODUCT(($A$2:$A$8=$A16)*($B$2:$B$8=$B16)*(D$2:D$8))
D17	=SUMPRODUCT(($A$2:$A$8=$A17)*($B$2:$B$8=$B17)*(D$2:D$8))
D18	=SUMPRODUCT(($A$2:$A$8=$A18)*($B$2:$B$8=$B18)*(D$2:D$8))
D19	=SUMPRODUCT(($A$2:$A$8=$A19)*($B$2:$B$8=$B19)*(D$2:D$8))
D20	=SUMPRODUCT(($A$2:$A$8=$A20)*($B$2:$B$8=$B20)*(D$2:D$8))
D21	=SUMPRODUCT(($A$2:$A$8=$A21)*($B$2:$B$8=$B21)*(D$2:D$8))
D22	=SUMPRODUCT(($A$2:$A$8=$A22)*($B$2:$B$8=$B22)*(D$2:D$8))
E11	=SUMPRODUCT(($A$2:$A$8=$A11)*($B$2:$B$8=$B11)*(E$2:E$8))
E12	=SUMPRODUCT(($A$2:$A$8=$A12)*($B$2:$B$8=$B12)*(E$2:E$8))
E13	=SUMPRODUCT(($A$2:$A$8=$A13)*($B$2:$B$8=$B13)*(E$2:E$8))
E14	=SUMPRODUCT(($A$2:$A$8=$A14)*($B$2:$B$8=$B14)*(E$2:E$8))
E15	=SUMPRODUCT(($A$2:$A$8=$A15)*($B$2:$B$8=$B15)*(E$2:E$8))
E16	=SUMPRODUCT(($A$2:$A$8=$A16)*($B$2:$B$8=$B16)*(E$2:E$8))
E17	=SUMPRODUCT(($A$2:$A$8=$A17)*($B$2:$B$8=$B17)*(E$2:E$8))
E18	=SUMPRODUCT(($A$2:$A$8=$A18)*($B$2:$B$8=$B18)*(E$2:E$8))
E19	=SUMPRODUCT(($A$2:$A$8=$A19)*($B$2:$B$8=$B19)*(E$2:E$8))
E20	=SUMPRODUCT(($A$2:$A$8=$A20)*($B$2:$B$8=$B20)*(E$2:E$8))
E21	=SUMPRODUCT(($A$2:$A$8=$A21)*($B$2:$B$8=$B21)*(E$2:E$8))
E22	=SUMPRODUCT(($A$2:$A$8=$A22)*($B$2:$B$8=$B22)*(E$2:E$8))
F11	=SUMPRODUCT(($A$2:$A$8=$A11)*($B$2:$B$8=$B11)*(F$2:F$8))
F12	=SUMPRODUCT(($A$2:$A$8=$A12)*($B$2:$B$8=$B12)*(F$2:F$8))
F13	=SUMPRODUCT(($A$2:$A$8=$A13)*($B$2:$B$8=$B13)*(F$2:F$8))
F14	=SUMPRODUCT(($A$2:$A$8=$A14)*($B$2:$B$8=$B14)*(F$2:F$8))
F15	=SUMPRODUCT(($A$2:$A$8=$A15)*($B$2:$B$8=$B15)*(F$2:F$8))
F16	=SUMPRODUCT(($A$2:$A$8=$A16)*($B$2:$B$8=$B16)*(F$2:F$8))
F17	=SUMPRODUCT(($A$2:$A$8=$A17)*($B$2:$B$8=$B17)*(F$2:F$8))
F18	=SUMPRODUCT(($A$2:$A$8=$A18)*($B$2:$B$8=$B18)*(F$2:F$8))
F19	=SUMPRODUCT(($A$2:$A$8=$A19)*($B$2:$B$8=$B19)*(F$2:F$8))
F20	=SUMPRODUCT(($A$2:$A$8=$A20)*($B$2:$B$8=$B20)*(F$2:F$8))
F21	=SUMPRODUCT(($A$2:$A$8=$A21)*($B$2:$B$8=$B21)*(F$2:F$8))
F22	=SUMPRODUCT(($A$2:$A$8=$A22)*($B$2:$B$8=$B22)*(F$2:F$8))
G11	=SUMPRODUCT(($A$2:$A$8=$A11)*($B$2:$B$8=$B11)*(G$2:G$8))
G12	=SUMPRODUCT(($A$2:$A$8=$A12)*($B$2:$B$8=$B12)*(G$2:G$8))
G13	=SUMPRODUCT(($A$2:$A$8=$A13)*($B$2:$B$8=$B13)*(G$2:G$8))
G14	=SUMPRODUCT(($A$2:$A$8=$A14)*($B$2:$B$8=$B14)*(G$2:G$8))
G15	=SUMPRODUCT(($A$2:$A$8=$A15)*($B$2:$B$8=$B15)*(G$2:G$8))
G16	=SUMPRODUCT(($A$2:$A$8=$A16)*($B$2:$B$8=$B16)*(G$2:G$8))
G17	=SUMPRODUCT(($A$2:$A$8=$A17)*($B$2:$B$8=$B17)*(G$2:G$8))
G18	=SUMPRODUCT(($A$2:$A$8=$A18)*($B$2:$B$8=$B18)*(G$2:G$8))
G19	=SUMPRODUCT(($A$2:$A$8=$A19)*($B$2:$B$8=$B19)*(G$2:G$8))
G20	=SUMPRODUCT(($A$2:$A$8=$A20)*($B$2:$B$8=$B20)*(G$2:G$8))
G21	=SUMPRODUCT(($A$2:$A$8=$A21)*($B$2:$B$8=$B21)*(G$2:G$8))
G22	=SUMPRODUCT(($A$2:$A$8=$A22)*($B$2:$B$8=$B22)*(G$2:G$8))
H11	=SUMPRODUCT(($A$2:$A$8=$A11)*($B$2:$B$8=$B11)*(H$2:H$8))
H12	=SUMPRODUCT(($A$2:$A$8=$A12)*($B$2:$B$8=$B12)*(H$2:H$8))
H13	=SUMPRODUCT(($A$2:$A$8=$A13)*($B$2:$B$8=$B13)*(H$2:H$8))
H14	=SUMPRODUCT(($A$2:$A$8=$A14)*($B$2:$B$8=$B14)*(H$2:H$8))
H15	=SUMPRODUCT(($A$2:$A$8=$A15)*($B$2:$B$8=$B15)*(H$2:H$8))
H16	=SUMPRODUCT(($A$2:$A$8=$A16)*($B$2:$B$8=$B16)*(H$2:H$8))
H17	=SUMPRODUCT(($A$2:$A$8=$A17)*($B$2:$B$8=$B17)*(H$2:H$8))
H18	=SUMPRODUCT(($A$2:$A$8=$A18)*($B$2:$B$8=$B18)*(H$2:H$8))
H19	=SUMPRODUCT(($A$2:$A$8=$A19)*($B$2:$B$8=$B19)*(H$2:H$8))
H20	=SUMPRODUCT(($A$2:$A$8=$A20)*($B$2:$B$8=$B20)*(H$2:H$8))
H21	=SUMPRODUCT(($A$2:$A$8=$A21)*($B$2:$B$8=$B21)*(H$2:H$8))
H22	=SUMPRODUCT(($A$2:$A$8=$A22)*($B$2:$B$8=$B22)*(H$2:H$8))
I11	=SUMPRODUCT(($A$2:$A$8=$A11)*($B$2:$B$8=$B11)*(I$2:I$8))
I12	=SUMPRODUCT(($A$2:$A$8=$A12)*($B$2:$B$8=$B12)*(I$2:I$8))
I13	=SUMPRODUCT(($A$2:$A$8=$A13)*($B$2:$B$8=$B13)*(I$2:I$8))
I14	=SUMPRODUCT(($A$2:$A$8=$A14)*($B$2:$B$8=$B14)*(I$2:I$8))
I15	=SUMPRODUCT(($A$2:$A$8=$A15)*($B$2:$B$8=$B15)*(I$2:I$8))
I16	=SUMPRODUCT(($A$2:$A$8=$A16)*($B$2:$B$8=$B16)*(I$2:I$8))
I17	=SUMPRODUCT(($A$2:$A$8=$A17)*($B$2:$B$8=$B17)*(I$2:I$8))
I18	=SUMPRODUCT(($A$2:$A$8=$A18)*($B$2:$B$8=$B18)*(I$2:I$8))
I19	=SUMPRODUCT(($A$2:$A$8=$A19)*($B$2:$B$8=$B19)*(I$2:I$8))
I20	=SUMPRODUCT(($A$2:$A$8=$A20)*($B$2:$B$8=$B20)*(I$2:I$8))
I21	=SUMPRODUCT(($A$2:$A$8=$A21)*($B$2:$B$8=$B21)*(I$2:I$8))
I22	=SUMPRODUCT(($A$2:$A$8=$A22)*($B$2:$B$8=$B22)*(I$2:I$8))
J11	=SUMPRODUCT(($A$2:$A$8=$A11)*($B$2:$B$8=$B11)*(J$2:J$8))
J12	=SUMPRODUCT(($A$2:$A$8=$A12)*($B$2:$B$8=$B12)*(J$2:J$8))
J13	=SUMPRODUCT(($A$2:$A$8=$A13)*($B$2:$B$8=$B13)*(J$2:J$8))
J14	=SUMPRODUCT(($A$2:$A$8=$A14)*($B$2:$B$8=$B14)*(J$2:J$8))
J15	=SUMPRODUCT(($A$2:$A$8=$A15)*($B$2:$B$8=$B15)*(J$2:J$8))
J16	=SUMPRODUCT(($A$2:$A$8=$A16)*($B$2:$B$8=$B16)*(J$2:J$8))
J17	=SUMPRODUCT(($A$2:$A$8=$A17)*($B$2:$B$8=$B17)*(J$2:J$8))
J18	=SUMPRODUCT(($A$2:$A$8=$A18)*($B$2:$B$8=$B18)*(J$2:J$8))
J19	=SUMPRODUCT(($A$2:$A$8=$A19)*($B$2:$B$8=$B19)*(J$2:J$8))
J20	=SUMPRODUCT(($A$2:$A$8=$A20)*($B$2:$B$8=$B20)*(J$2:J$8))
J21	=SUMPRODUCT(($A$2:$A$8=$A21)*($B$2:$B$8=$B21)*(J$2:J$8))
J22	=SUMPRODUCT(($A$2:$A$8=$A22)*($B$2:$B$8=$B22)*(J$2:J$8))
K11	=SUMPRODUCT(($A$2:$A$8=$A11)*($B$2:$B$8=$B11)*(K$2:K$8))
K12	=SUMPRODUCT(($A$2:$A$8=$A12)*($B$2:$B$8=$B12)*(K$2:K$8))
K13	=SUMPRODUCT(($A$2:$A$8=$A13)*($B$2:$B$8=$B13)*(K$2:K$8))
K14	=SUMPRODUCT(($A$2:$A$8=$A14)*($B$2:$B$8=$B14)*(K$2:K$8))
K15	=SUMPRODUCT(($A$2:$A$8=$A15)*($B$2:$B$8=$B15)*(K$2:K$8))
K16	=SUMPRODUCT(($A$2:$A$8=$A16)*($B$2:$B$8=$B16)*(K$2:K$8))
K17	=SUMPRODUCT(($A$2:$A$8=$A17)*($B$2:$B$8=$B17)*(K$2:K$8))
K18	=SUMPRODUCT(($A$2:$A$8=$A18)*($B$2:$B$8=$B18)*(K$2:K$8))
K19	=SUMPRODUCT(($A$2:$A$8=$A19)*($B$2:$B$8=$B19)*(K$2:K$8))
K20	=SUMPRODUCT(($A$2:$A$8=$A20)*($B$2:$B$8=$B20)*(K$2:K$8))
K21	=SUMPRODUCT(($A$2:$A$8=$A21)*($B$2:$B$8=$B21)*(K$2:K$8))
K22	=SUMPRODUCT(($A$2:$A$8=$A22)*($B$2:$B$8=$B22)*(K$2:K$8))
L11	=SUMPRODUCT(($A$2:$A$8=$A11)*($B$2:$B$8=$B11)*(L$2:L$8))
L12	=SUMPRODUCT(($A$2:$A$8=$A12)*($B$2:$B$8=$B12)*(L$2:L$8))
L13	=SUMPRODUCT(($A$2:$A$8=$A13)*($B$2:$B$8=$B13)*(L$2:L$8))
L14	=SUMPRODUCT(($A$2:$A$8=$A14)*($B$2:$B$8=$B14)*(L$2:L$8))
L15	=SUMPRODUCT(($A$2:$A$8=$A15)*($B$2:$B$8=$B15)*(L$2:L$8))
L16	=SUMPRODUCT(($A$2:$A$8=$A16)*($B$2:$B$8=$B16)*(L$2:L$8))
L17	=SUMPRODUCT(($A$2:$A$8=$A17)*($B$2:$B$8=$B17)*(L$2:L$8))
L18	=SUMPRODUCT(($A$2:$A$8=$A18)*($B$2:$B$8=$B18)*(L$2:L$8))
L19	=SUMPRODUCT(($A$2:$A$8=$A19)*($B$2:$B$8=$B19)*(L$2:L$8))
L20	=SUMPRODUCT(($A$2:$A$8=$A20)*($B$2:$B$8=$B20)*(L$2:L$8))
L21	=SUMPRODUCT(($A$2:$A$8=$A21)*($B$2:$B$8=$B21)*(L$2:L$8))
L22	=SUMPRODUCT(($A$2:$A$8=$A22)*($B$2:$B$8=$B22)*(L$2:L$8))
M11	=SUMPRODUCT(($A$2:$A$8=$A11)*($B$2:$B$8=$B11)*(M$2:M$8))
M12	=SUMPRODUCT(($A$2:$A$8=$A12)*($B$2:$B$8=$B12)*(M$2:M$8))
M13	=SUMPRODUCT(($A$2:$A$8=$A13)*($B$2:$B$8=$B13)*(M$2:M$8))
M14	=SUMPRODUCT(($A$2:$A$8=$A14)*($B$2:$B$8=$B14)*(M$2:M$8))
M15	=SUMPRODUCT(($A$2:$A$8=$A15)*($B$2:$B$8=$B15)*(M$2:M$8))
M16	=SUMPRODUCT(($A$2:$A$8=$A16)*($B$2:$B$8=$B16)*(M$2:M$8))
M17	=SUMPRODUCT(($A$2:$A$8=$A17)*($B$2:$B$8=$B17)*(M$2:M$8))
M18	=SUMPRODUCT(($A$2:$A$8=$A18)*($B$2:$B$8=$B18)*(M$2:M$8))
M19	=SUMPRODUCT(($A$2:$A$8=$A19)*($B$2:$B$8=$B19)*(M$2:M$8))
M20	=SUMPRODUCT(($A$2:$A$8=$A20)*($B$2:$B$8=$B20)*(M$2:M$8))
M21	=SUMPRODUCT(($A$2:$A$8=$A21)*($B$2:$B$8=$B21)*(M$2:M$8))
M22	=SUMPRODUCT(($A$2:$A$8=$A22)*($B$2:$B$8=$B22)*(M$2:M$8))
N11	=SUMPRODUCT(($A$2:$A$8=$A11)*($B$2:$B$8=$B11)*(N$2:N$8))
N12	=SUMPRODUCT(($A$2:$A$8=$A12)*($B$2:$B$8=$B12)*(N$2:N$8))
N13	=SUMPRODUCT(($A$2:$A$8=$A13)*($B$2:$B$8=$B13)*(N$2:N$8))
N14	=SUMPRODUCT(($A$2:$A$8=$A14)*($B$2:$B$8=$B14)*(N$2:N$8))
N15	=SUMPRODUCT(($A$2:$A$8=$A15)*($B$2:$B$8=$B15)*(N$2:N$8))
N16	=SUMPRODUCT(($A$2:$A$8=$A16)*($B$2:$B$8=$B16)*(N$2:N$8))
N17	=SUMPRODUCT(($A$2:$A$8=$A17)*($B$2:$B$8=$B17)*(N$2:N$8))
N18	=SUMPRODUCT(($A$2:$A$8=$A18)*($B$2:$B$8=$B18)*(N$2:N$8))
N19	=SUMPRODUCT(($A$2:$A$8=$A19)*($B$2:$B$8=$B19)*(N$2:N$8))
N20	=SUMPRODUCT(($A$2:$A$8=$A20)*($B$2:$B$8=$B20)*(N$2:N$8))
N21	=SUMPRODUCT(($A$2:$A$8=$A21)*($B$2:$B$8=$B21)*(N$2:N$8))
N22	=SUMPRODUCT(($A$2:$A$8=$A22)*($B$2:$B$8=$B22)*(N$2:N$8))
O11	=SUMPRODUCT(($A$2:$A$8=$A11)*($B$2:$B$8=$B11)*(O$2:O$8))
O12	=SUMPRODUCT(($A$2:$A$8=$A12)*($B$2:$B$8=$B12)*(O$2:O$8))
O13	=SUMPRODUCT(($A$2:$A$8=$A13)*($B$2:$B$8=$B13)*(O$2:O$8))
O14	=SUMPRODUCT(($A$2:$A$8=$A14)*($B$2:$B$8=$B14)*(O$2:O$8))
O15	=SUMPRODUCT(($A$2:$A$8=$A15)*($B$2:$B$8=$B15)*(O$2:O$8))
O16	=SUMPRODUCT(($A$2:$A$8=$A16)*($B$2:$B$8=$B16)*(O$2:O$8))
O17	=SUMPRODUCT(($A$2:$A$8=$A17)*($B$2:$B$8=$B17)*(O$2:O$8))
O18	=SUMPRODUCT(($A$2:$A$8=$A18)*($B$2:$B$8=$B18)*(O$2:O$8))
O19	=SUMPRODUCT(($A$2:$A$8=$A19)*($B$2:$B$8=$B19)*(O$2:O$8))
O20	=SUMPRODUCT(($A$2:$A$8=$A20)*($B$2:$B$8=$B20)*(O$2:O$8))
O21	=SUMPRODUCT(($A$2:$A$8=$A21)*($B$2:$B$8=$B21)*(O$2:O$8))
O22	=SUMPRODUCT(($A$2:$A$8=$A22)*($B$2:$B$8=$B22)*(O$2:O$8))
P11	=SUMPRODUCT(($A$2:$A$8=$A11)*($B$2:$B$8=$B11)*(P$2:P$8))
P12	=SUMPRODUCT(($A$2:$A$8=$A12)*($B$2:$B$8=$B12)*(P$2:P$8))
P13	=SUMPRODUCT(($A$2:$A$8=$A13)*($B$2:$B$8=$B13)*(P$2:P$8))
P14	=SUMPRODUCT(($A$2:$A$8=$A14)*($B$2:$B$8=$B14)*(P$2:P$8))
P15	=SUMPRODUCT(($A$2:$A$8=$A15)*($B$2:$B$8=$B15)*(P$2:P$8))
P16	=SUMPRODUCT(($A$2:$A$8=$A16)*($B$2:$B$8=$B16)*(P$2:P$8))
P17	=SUMPRODUCT(($A$2:$A$8=$A17)*($B$2:$B$8=$B17)*(P$2:P$8))
P18	=SUMPRODUCT(($A$2:$A$8=$A18)*($B$2:$B$8=$B18)*(P$2:P$8))
P19	=SUMPRODUCT(($A$2:$A$8=$A19)*($B$2:$B$8=$B19)*(P$2:P$8))
P20	=SUMPRODUCT(($A$2:$A$8=$A20)*($B$2:$B$8=$B20)*(P$2:P$8))
P21	=SUMPRODUCT(($A$2:$A$8=$A21)*($B$2:$B$8=$B21)*(P$2:P$8))
P22	=SUMPRODUCT(($A$2:$A$8=$A22)*($B$2:$B$8=$B22)*(P$2:P$8))
Q11	=SUMPRODUCT(($A$2:$A$8=$A11)*($B$2:$B$8=$B11)*(Q$2:Q$8))
Q12	=SUMPRODUCT(($A$2:$A$8=$A12)*($B$2:$B$8=$B12)*(Q$2:Q$8))
Q13	=SUMPRODUCT(($A$2:$A$8=$A13)*($B$2:$B$8=$B13)*(Q$2:Q$8))
Q14	=SUMPRODUCT(($A$2:$A$8=$A14)*($B$2:$B$8=$B14)*(Q$2:Q$8))
Q15	=SUMPRODUCT(($A$2:$A$8=$A15)*($B$2:$B$8=$B15)*(Q$2:Q$8))
Q16	=SUMPRODUCT(($A$2:$A$8=$A16)*($B$2:$B$8=$B16)*(Q$2:Q$8))
Q17	=SUMPRODUCT(($A$2:$A$8=$A17)*($B$2:$B$8=$B17)*(Q$2:Q$8))
Q18	=SUMPRODUCT(($A$2:$A$8=$A18)*($B$2:$B$8=$B18)*(Q$2:Q$8))
Q19	=SUMPRODUCT(($A$2:$A$8=$A19)*($B$2:$B$8=$B19)*(Q$2:Q$8))
Q20	=SUMPRODUCT(($A$2:$A$8=$A20)*($B$2:$B$8=$B20)*(Q$2:Q$8))
Q21	=SUMPRODUCT(($A$2:$A$8=$A21)*($B$2:$B$8=$B21)*(Q$2:Q$8))
Q22	=SUMPRODUCT(($A$2:$A$8=$A22)*($B$2:$B$8=$B22)*(Q$2:Q$8))

 

[Geger]

Re: Help with Index & Match... not working at all!

Thank you yky this worked really well !!!!

I'm running into a small problem. Since I update the file below - and it's a pivot table now my formulas don't work I'll have to find out why that is happening.

Thank you!!!!
Geger

 

[Geger]

Re: Help with Index & Match... not working at all!

Thank you for sending me your solution - I have noted this as a second option for me

thank you kindly
geger