how to do this lookup?

[bigdan]

Please see table below.

I'm trying to figure out how to do a lookup for these values?

For example if I wanted to know how many CPU's were sold by Dell, the answer below is 11. But what would be the way to do that lookup? I know how to do vlookups and sumifs but can't figure this one out.

Thanks!

	Walmart	Target	Dell	Amazon
Toothbrush	1	2	3	4
Toothpaste	5	6	7	8
CPU	9	10	11	12
Monitor	13	14	15	16

<tbody>
</tbody>

 

[Legacy 436357]

Maybe like this:

Excel Workbook
	B	C	D	E	F	G	H
2		Walmart	Target	Dell	Amazon		CPU
3	Toothbrush	1	2	3	4		Dell
4	Toothpaste	5	6	7	8		11
5	CPU	9	10	11	12
6	Monitor	13	14	15	16
Sheet1

 

[Fluff]

Another option

Excel 2013/2016
	A	B	C	D	E	F	G	H
1		Walmart	Target	Dell	Amazon		CPU	Dell
2	Toothbrush	1	2	3	4		11
3	Toothpaste	5	6	7	8
4	CPU	9	10	11	12
5	Monitor	13	14	15	16
Cover

Cell Formulas
Range	Formula
G2	=INDEX(B2:E5,MATCH(G1,A2:A5,0),MATCH(H1,B1:E1,0))

 

[bigdan]

thanks guys!

 

[Fluff]

Glad we could help & thanks for the feedback