Is there a double Vlook Up Formula or Another Formula To Perfom This Quickly?

[newboy2020]

I am trying to figure out if there is a formula or a double vlook up forumla which can quickly calculate the results I have manually input in Cells C2,C3,C4 using the values from Columns G,H,I

Sum_Test.xlsx
	A	B	C	D	E	F	G	H	I
1	# of Cartons	# of Pallets	Price				# of Cartons	# of Pallets	Price
2	3	13	$ 1,630.00				2	1	265
3	2	5	$ 480.00				2	2	325
4	3	16	$ 2,630.00				2	3	380
5	3	8					2	4	435
6	3	17					2	5	480
7	3	7					2	6	525
8	2	18					2	7	570
9	2	6					2	8	615
10	3	8					2	9	660
11	3	15					2	10	705
12	4	9					6	1	750
13	3	7					6	52	795
14	2	6					2	13	840
15	2	4					2	14	885
16	2	9					2	15	930
17	2	11					2	16	1030
18	2	12					2	17	1130
19	2	5					2	18	1230
20	2	20					2	19	1330
21	3	13					2	20	1430
22	2	20					2	21	1530
23	2	12					3	13	1630
24	2	10					12	1	1730
25	3	52					2	24	1830
26	6	52					2	25	1930
27	6	1					2	26	2030
28	12	1					2	27	2130
29	1	Multiple					2	28	2230
30	3	10					3	10	2330
31	3	10					3	15	2430
32	6	12					3	8	2530
33							3	16	2630
Sheet1

Cell Formulas
Range	Formula
I17:I33	I17	=I16+100

 

[lrobbo314]

Book2
	A	B	C	D	E	F	G	H	I
1	# of Cartons	# of Pallets	Price				# of Cartons	# of Pallets	Price
2	3	13	1630				2	1	265
3	2	5	480				2	2	325
4	3	16	2630				2	3	380
5	3	8	2530				2	4	435
6	3	17	0				2	5	480
7	3	7	0				2	6	525
8	2	18	1230				2	7	570
9	2	6	525				2	8	615
10	3	8	2530				2	9	660
11	3	15	2430				2	10	705
12	4	9	0				6	1	750
13	3	7	0				6	52	795
14	2	6	525				2	13	840
15	2	4	435				2	14	885
16	2	9	660				2	15	930
17	2	11	0				2	16	1030
18	2	12	0				2	17	1130
19	2	5	480				2	18	1230
20	2	20	1430				2	19	1330
21	3	13	1630				2	20	1430
22	2	20	1430				2	21	1530
23	2	12	0				3	13	1630
24	2	10	705				12	1	1730
25	3	52	0				2	24	1830
26	6	52	795				2	25	1930
27	6	1	750				2	26	2030
28	12	1	1730				2	27	2130
29	1	Multiple	0				2	28	2230
30	3	10	2330				3	10	2330
31	3	10	2330				3	15	2430
32	6	12	0				3	8	2530
33							3	16	2630
Sheet1

Cell Formulas
Range	Formula
C2:C32	C2	=SUMPRODUCT(($G$2:$G$33=A2)*($H$2:$H$33=B2)*($I$2:$I$33))
I17:I33	I17	=I16+100

 

[Fluff]

Another option

+Fluff v2.xlsm
	A	B	C	D	E	F	G	H	I
1	# of Cartons	# of Pallets	Price				# of Cartons	# of Pallets	Price
2	3	13	1630				2	1	265
3	2	5	480				2	2	325
4	3	16	2630				2	3	380
5	3	8	2530				2	4	435
6	3	17	0				2	5	480
7	3	7	0				2	6	525
8	2	18	1230				2	7	570
9	2	6	525				2	8	615
10	3	8	2530				2	9	660
11	3	15	2430				2	10	705
12	4	9	0				6	1	750
13	3	7	0				6	52	795
14	2	6	525				2	13	840
15	2	4	435				2	14	885
16	2	9	660				2	15	930
17	2	11	0				2	16	1030
18	2	12	0				2	17	1130
19	2	5	480				2	18	1230
20	2	20	1430				2	19	1330
21	3	13	1630				2	20	1430
22	2	20	1430				2	21	1530
23	2	12	0				3	13	1630
24	2	10	705				12	1	1730
25	3	52	0				2	24	1830
26	6	52	795				2	25	1930
27	6	1	750				2	26	2030
28	12	1	1730				2	27	2130
29	1	Multiple	0				2	28	2230
30	3	10	2330				3	10	2330
31	3	10	2330				3	15	2430
32	6	12	0				3	8	2530
33							3	16	2630
Master

Cell Formulas
Range	Formula
C2:C32	C2	=SUMIFS(I:I,G:G,A2,H:H,B2)
I17:I33	I17	=I16+100

 

[lrobbo314]

Or possibly

=IFERROR(AGGREGATE(14,6,1/(($G$2:$G$33=A2)/($H$2:$H$33=B2))*$I$2:$I$33,1),"Not Found")

 

[newboy2020]

Thank you very much to all who replied, very much appreciate the help.

 

[Fluff]

Glad we could help & thanks for the feedback.