Extract values from one table into another table

[hamohd70]

I have the following sample table where I enter my data on monthly basis:

Date	CGP	CS-2	SITRA
Jan-01	2215	72414	7589
Feb-01	2145	63568	6830
Mar-01	2446	74855	8196
Apr-01	2590	60728	1151
May-01	2875	65280	9891
Jun-01	2867	59997	8970
Jul-01	2996	61450	9150
Aug-01	3009	65532	9682
Sep-01	2921	65571	8937
Oct-01	2884	88706	7900
Nov-01	2555	22510	7276
Dec-01	2529	53550	8622
Jan-02	2403500	74229	608200
Feb-02	2152300	69525	635900
Mar-02	2473300	74151	753100
Apr-02	2548800	59871	766100
May-02	2915300	10951	819200
Jun-02	2901000	10533	878200
Jul-02	3069700	11938	937800
Aug-02	3150600	11327	902800
Sep-02	2995500	9551	818900
Oct-02	2938600	64558	827600
Nov-02	2545700	69138	739000
Dec-02	2441800	186034	680300

<tbody>
</tbody>

Then I have the following table where I filled by extracting data from the first table

Year: 2001

AREA	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
CGP	2215	2145	2446	2590	2875	2867	2996	3009	2921	2884	2555	2529
SITRA	7589	6830	8196	1151	9891	8970	9150	9682	8937	7900	7276	8622

<tbody>
</tbody>

my request is this: I want to extract values from the first table into the second table if the conditions is met.

The conditions are: extract values from table 1 where the area matches the one on the left most column (like "CGP" or "SITRA") and the month matches the months on the top row and the year is 2001. The value will change when the year is changed.

I need to put the formulas in an excel table.

Can you please help me with this.

 

[MARZIOTULLIO]

A​

B​

C​

D​

E​

F​

G​

H​

I​

J​

K​

L​

M​

1​

Date

CGP

CS-2

SITRA

2​

1/1/2001​

2215​

72414​

7589​

3​

2/1/2001​

2145​

63568​

6830​

4​

3/1/2001​

2446​

74855​

8196​

5​

4/1/2001​

2590​

60728​

1151​

6​

5/1/2001​

2875​

65280​

9891​

7​

6/1/2001​

2867​

59997​

8970​

8​

7/1/2001​

2996​

61450​

9150​

9​

8/1/2001​

3009​

65532​

9682​

10​

9/1/2001​

2921​

65571​

8937​

11​

10/1/2001​

2884​

88706​

7900​

12​

11/1/2001​

2555​

22510​

7276​

13​

12/1/2001​

2529​

53550​

8622​

14​

1/2/2002​

2403500​

74229​

608200​

15​

2/2/2002​

2152300​

69525​

635900​

16​

3/2/2002​

2473300​

74151​

753100​

17​

4/2/2002​

2548800​

59871​

766100​

18​

5/2/2002​

2915300​

10951​

819200​

19​

6/2/2002​

2901000​

10533​

878200​

20​

7/2/2002​

3069700​

11938​

937800​

21​

8/2/2002​

3150600​

11327​

902800​

22​

9/2/2002​

2995500​

9551​

818900​

23​

10/2/2002​

2938600​

64558​

827600​

24​

11/2/2002​

2545700​

69138​

739000​

25​

12/2/2002​

2441800​

186034​

680300​

26​

27​

28​

29​

30​

Year

2001​

31​

32​

AREA

JAN​

FEB​

MAR​

APR​

MAY​

JUN​

JUL​

AUG​

SEP​

OCT​

NOV​

DEC​

33​

CGP

2215​

2145​

2446​

2590​

2875​

2867​

2996​

3009​

2921​

2884​

2555​

2529​

34​

SITRA

7589​

6830​

8196​

1151​

9891​

8970​

9150​

9682​

8937​

7900​

7276​

8622​

<tbody>
</tbody>

B33=SUMPRODUCT(($B$1:$D$1=$A33)*(MONTH($A$2:$A$25)=MONTH(B$32&0))*(YEAR($A$2:$A$25)=$B$30)*($B$2:$D$25)) copy across and down



For year 2002 :Change B30 from 2001 to 2002

Month are text

 

[hamohd70]

Worked perfectly. Thanks