Look up value from a pivot table

[icytuvi]

Hi,

Sorry for troubling you guys with this simple question but it's not simple to me at all.
I want to look up data from a pivot table which has the same structure, as in the example below.
Could you kindly help me with the formula?

Thank you so much.

Book1
	A	B	C	D	E	F	G	H
2	Area	Product	Jan		Feb		Mar
3			Q'ty	Revenue	Q'ty	Revenue	Q'ty	Revenue
4	North	Milk	100	5,000	10	500	30	1500
5	North	Tea	50	2,500	20	1,000	50	2500
6	North	Cake	150	7,500	30	1,500	70	3500
7	South	Milk	200	10,000	40	2,000	90	4500
8	South	Tea	300	15,000	50	2,500	110	5500
9	South	Cake	250	12,500	60	3,000	130	6500
10
11
12	Area	Product	Jan		Feb		Mar
13			Q'ty	Revenue	Q'ty	Revenue	Q'ty	Revenue
14	North	Milk
15	North	Tea
16	North	Cake
17	South	Milk
18	South	Tea
19	South	Cake
Sheet1

Cell Formulas
Range	Formula
D4:D9,H4:H9,F4:F9	D4	=C4*50
E5:E9	E5	=E4+10
G5:G9	G5	=G4+20