Index & Match or Other Look up Advice

[Joneye]

Amazing people of Excel, I would love to hear your advice on which is the best look up or match formula to search Table A and report the answer in Table B.

For table B Cell Names "Customer" & "Quanity" will be drop down fields, with the answer populating in the titled box "Answer" (here is where i'd love to some help on a formula.

Table A

Customer	Item	1,000	5,000	10,000
	Item 1	1	2	3
	Item 2	1	2	3
	Item 3	1	2	3
	Item 4	1	2	3
	Item 5	1	2	3
	item 6	1	2	3
	item 7	1	2	3
Customer A	TOTAL	7	14	21
	Item 1	4	5	6
	Item 2	4	5	6
	Item 3	4	5	6
	Item 4	4	5	6
	Item 5	4	5	6
Customer B	TOTAL	20	25	30
	Item 1	7	8	9
	Item 2	7	8	9
	Item 3	7	8	9
	Item 4	7	8	9
	Item 5	7	8	9
Customer C	TOTAL	35	40	45
Table B
Customer	Quantity	Answer
Customer C	5,000	40

 

[SunnyAlv]

like this ?

=SUMPRODUCT((A3:A22=G3)*(C2:E2=H3)*C3:E22)

 

[Joneye]

Thank you, makes sense, and works just fine for me. Huge thank you