Creating a formula to Search data set and return specific number

[TexasTea]

I have the below data set and I need that information to complete the below table. The below data set is a small example, where you see Cat 1, Cat 2, etc - there are actually 30 of these.
I need to fill in the below table, and need help creating the correct index, match or offset formula to complete this.

Thanks for any help you can provide.

The Data Set:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Dollars[/TD]
[TD]Dollars[/TD]
[TD]Units[/TD]
[TD]Units[/TD]
[/TR]
[TR]
[TD]Categories[/TD]
[TD]Months[/TD]
[TD]Customer 1[/TD]
[TD]Market[/TD]
[TD]Customer 1[/TD]
[TD]Market[/TD]
[/TR]
[TR]
[TD]Cat 1[/TD]
[TD]Jan[/TD]
[TD]10,000[/TD]
[TD]50,000[/TD]
[TD]2,000[/TD]
[TD]12,000[/TD]
[/TR]
[TR]
[TD]Cat 1[/TD]
[TD]Feb[/TD]
[TD]20,000[/TD]
[TD]60,000[/TD]
[TD]4,000[/TD]
[TD]14,000[/TD]
[/TR]
[TR]
[TD]Cat 1[/TD]
[TD]Mar[/TD]
[TD]30,000[/TD]
[TD]70,000[/TD]
[TD]6,000[/TD]
[TD]16,000[/TD]
[/TR]
[TR]
[TD]Cat 2[/TD]
[TD]Jan[/TD]
[TD]5,000[/TD]
[TD]30,000[/TD]
[TD]1,000[/TD]
[TD]11,000[/TD]
[/TR]
[TR]
[TD]Cat 2[/TD]
[TD]Feb[/TD]
[TD]15,000[/TD]
[TD]35,000[/TD]
[TD]3,000[/TD]
[TD]13,000[/TD]
[/TR]
[TR]
[TD]Cat 2[/TD]
[TD]Mar[/TD]
[TD]25,000[/TD]
[TD]40,000[/TD]
[TD]5,000[/TD]
[TD]15,000[/TD]
[/TR]
[TR]
[TD]Cat 3[/TD]
[TD]Jan[/TD]
[TD]5,000[/TD]
[TD]10,000[/TD]
[TD]6,000[/TD]
[TD]11,000[/TD]
[/TR]
[TR]
[TD]Cat 3
[/TD]
[TD]Feb[/TD]
[TD]30,000[/TD]
[TD]35,000[/TD]
[TD]3,000[/TD]
[TD]12,000[/TD]
[/TR]
[TR]
[TD]Cat 3[/TD]
[TD]Mar[/TD]
[TD]5,000[/TD]
[TD]50,000[/TD]
[TD]6,000[/TD]
[TD]14,000[/TD]
[/TR]
[TR]
[TD]Cat 4[/TD]
[TD]Jan[/TD]
[TD]5,000[/TD]
[TD]60,000[/TD]
[TD]1,000[/TD]
[TD]12,000[/TD]
[/TR]
[TR]
[TD]Cat 4[/TD]
[TD]Feb[/TD]
[TD]10,000[/TD]
[TD]30,000[/TD]
[TD]1,000[/TD]
[TD]11,000[/TD]
[/TR]
[TR]
[TD]Cat 4[/TD]
[TD]Mar[/TD]
[TD]40,000[/TD]
[TD]70,000[/TD]
[TD]3,000[/TD]
[TD]16,000[/TD]
[/TR]
</tbody>[/TABLE]


Table:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Category[/TD]
[TD]Month[/TD]
[TD]Customer 1 Dollars[/TD]
[TD]Customer 1 Units[/TD]
[/TR]
[TR]
[TD]Cat 1[/TD]
[TD]Mar[/TD]
[TD](return the number 30,000)[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]Cat 1[/TD]
[TD]Feb[/TD]
[TD]?[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]Cat 2[/TD]
[TD]Mar[/TD]
[TD]?[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]Cat 2[/TD]
[TD]Feb[/TD]
[TD]?[/TD]
[TD]?[/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

Hi,

This is strictly based on your sample, will probably need modifications since there are no provisions for Customer 2, 3, etc.

Book1
	A	B	C	D	E	F
1			Dollars	Dollars	Units	Units
2	Categories	Months	Customer 1	Market	Customer 1	Market
3	Cat 1	Jan	10,000	50,000	2,000	12,000
4	Cat 1	Feb	20,000	60,000	4,000	14,000
5	Cat 1	Mar	30,000	70,000	6,000	16,000
6	Cat 2	Jan	5,000	30,000	1,000	11,000
7	Cat 2	Feb	15,000	35,000	3,000	13,000
8	Cat 2	Mar	25,000	40,000	5,000	15,000
9	Cat 3	Jan	5,000	10,000	6,000	11,000
10	Cat 3	Feb	30,000	35,000	3,000	12,000
11	Cat 3	Mar	5,000	50,000	6,000	14,000
12	Cat 4	Jan	5,000	60,000	1,000	12,000
13	Cat 4	Feb	10,000	30,000	1,000	11,000
14	Cat 4	Mar	40,000	70,000	3,000	16,000
15
16
17	Table:
18			Dollars	Units
19	Category	Month	Customer 1	Customer 1
20	Cat 1	Mar	30000	6000
21	Cat 1	Feb	20000	4000
22	Cat 2	Mar	25000	5000
23	Cat 2	Feb	15000	3000
Sheet10

Cell Formulas
Range	Formula
C20	=IF(C$2=C$19,SUMIFS(C$3:C$14,A$3:A$14,A20,B$3:B$14,B20),"")
D20	=IF(E$2=D$19,SUMIFS(E$3:E$14,A$3:A$14,A20,B$3:B$14,B20),"")

C20 and D20 formulae copied down.