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!


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Walmart[/TD]
[TD]Target[/TD]
[TD]Dell[/TD]
[TD]Amazon[/TD]
[/TR]
[TR]
[TD]Toothbrush[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Toothpaste[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]CPU[/TD]
[TD]9[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Monitor[/TD]
[TD]13[/TD]
[TD]14[/TD]
[TD]15[/TD]
[TD]16[/TD]
[/TR]
</tbody>[/TABLE]

 

[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