finding data date wise

[azii]

Respected All
I have data in excel table 1 [e.g horizontally moving date wise and in between there are three companies (Fatima, Engro and Sona/ffc) ]
I need if I enter a date in a cell then data in shape of table 2 should be appear. I am stuck and couldn't find any way to solve it. please help me.


Table 1

Receiving Date		16-Nov-2012	26-Nov-2012	27-Dec- 2012	28-Feb-2013	5-Mar-2013	22-03-13
Parameters	Unit	Fatima	Fatima	Fatima	Fatima	Fatima	Fatima
Moisture	%	0.18	0.11	0.14	0.25	0.22	0.21
Biuret	%	0.97	0.97	1.12	1.03	0.91	1
Mesh Size
+2.80 mm	%	2.5	6.5	2.1	2.0	5.7	3.8
+2.40 mm	%	16.4	17.5	14.0	13.6	17.7	20.4
+2.00 mm	%	46.7	39.4	46.7	45.8	40.2	44.1
+1.70 mm	%	25.3	31.1	29.0	24.3	24.1	24.5
+1.40 mm	%	5.6	4.5	5.2	8.0	7.0	5.0
+1.00 mm	%	2.5	0.9	1.5	4.3	2.5	1.4
+0.50 mm	%	0.8	0.1	0.8	1.7	1.9	0.7
-0.50 mm	%	0.2	0	0.7	0.3	0.9	0.1
1 ~ 2.4 mm	%	96.5	93.4	96.4	96.0	91.5	95.5
Fines	%	1.0	0.1	1.5	2.0	2.8	0.8
Avg. Prill Size	mm	2.11	2.17	2.09	2.05	2.11	2.16
Avg. Crush Strength	Grams	807	1231	806	806	802	817
Parameters	Unit	Engro	Engro	Engro	Engro	Engro	Engro
Moisture	%	0.21	0.14	0.22	0.32	0.24	0.27
Biuret	%	1.03	0.8	0.99	1.19	0.94	1.02
Mesh Size
+2.80 mm	%	5.5	79.1	4.6	0.9	6.3	5.8
+2.40 mm	%	14.6	14.7	13.3	9.0	17.3	17.1
+2.00 mm	%	34.2	4.7	34.2	28.4	36.1	32.3
+1.70 mm	%	35.0	4.4	36.4	50.3	29.6	37.1
+1.40 mm	%	8.4	0.3	9.4	6.0	8.5	6.0
+1.00 mm	%	1.6	0.1	1.6	2.6	1.5	1.0
+0.50 mm	%	0.5	0	0.4	1.8	0.5	0.6
-0.50 mm	%	0.2	0	0.1	1.0	0.2	0.1
1 ~ 2.4 mm	%	93.8	20.9	94.9	96.3	93.0	93.5
Fines	%	0.7	0	0.5	2.8	0.7	0.7
Avg. Prill Size	mm	2.09	2.94	2.07	1.95	2.13	2.1
Avg. Crush Strength	Grams	819	4645	804	801	806	812.0
Parameters	Unit	Sona/ffc	Sona/ffc	Sona/ffc	Sona/ffc	Sona/ffc	Sona/ffc
Moisture	%	0.10	0.19	0.16	0.22	0.23	0.24
Biuret	%	0.88	0.96	0.91	0.91	0.92	0.9
Mesh Size
+2.80 mm	%	5.7	3	3.9	7.8	5.3	3.3
+2.40 mm	%	15.9	14.5	10.3	18.7	17.9	10.6
+2.00 mm	%	31.9	60.8	70.0	52.0	41.1	62.8
+1.70 mm	%	34.7	18.8	13.1	13.0	25.4	20.2
+1.40 mm	%	9.6	1.9	1.6	4.9	7.2	1.8
+1.00 mm	%	1.5	0.9	0.7	2.4	2.1	0.8
+0.50 mm	%	0.5	0.1	0.3	1.1	0.9	0.4
-0.50 mm	%	0.2	0	0.1	0.1	0.1	0.1
1 ~ 2.4 mm	%	93.6	96.9	95.7	91.0	93.7	96.2
Fines	%	0.7	0.1	0.4	1.2	1.0	0.5
Avg. Prill Size	mm	2.09	2.18	2.19	2.21	2.14	2.16
Avg. Crush Strength	Grams	814	951	821	822	808	819

<colgroup><col><col span="3"><col span="2"><col><col></colgroup><tbody>
</tbody>

green date will be typed

Table 2

Receiving Date		22-03-13
Parameters	Unit	Fatima	Engro	Sona/ffc
Moisture	%	0.21	0.27	0.24
Biuret	%	1	1.02	0.9
Mesh Size
+2.80 mm	%	3.8	5.8	3.3
+2.40 mm	%	20.4	17.1	10.6
+2.00 mm	%	44.1	32.3	62.8
+1.70 mm	%	24.5	37.1	20.2
+1.40 mm	%	5.0	6.0	1.8
+1.00 mm	%	1.4	1.0	0.8
+0.50 mm	%	0.7	0.6	0.4
-0.50 mm	%	0.1	0.1	0.1
1 ~ 2.4 mm	%	95.5	93.5	96.2
Fines	%	0.8	0.7	0.5
Avg. Prill Size	mm	2.16	2.1	2.16
Avg. Crush Strength	Grams	817	812.0	819

<colgroup><col><col span="4"></colgroup><tbody>
</tbody>

 

[CSyx]

azii,

Have you tried using an INDEX and MATCH formula? Try something like...=index(C:E,3,match(cell you enter date in,C1:E1,0)) and then fill down. Change the row number as needed.

 

[azii]

CSyx thank you for this guidance
I put the formula for Fatima which is =INDEX($C$2:$H$50,0,MATCH($K$2,$C2:$H2,0))
formula for Engro is =INDEX($C$2:$H$50,0,MATCH($K$2,C19:H19,0))
and for Sona/ffc is =INDEX($C$2:$H$50,0,MATCH($K$2,C35:H35,0))
as engro starts from row c19 and sona/ffc starts from c35
why #N/A is showing plz help.

see the result

27-12-12
Fatima	Angro	Sona/ffc
0.14	#N/A	#N/A
#N/A	#N/A	#N/A
#N/A	#N/A	#N/A
#N/A	#N/A	#N/A
#N/A	#N/A	#N/A
#N/A	#N/A	#N/A
#N/A	#N/A	#N/A
#N/A	#N/A	#N/A
#N/A	#N/A	#N/A
#N/A	#N/A	#N/A
#N/A	#N/A	#N/A
#N/A	#N/A	#N/A
#N/A	#N/A	#N/A
#N/A	#N/A	#N/A
#N/A	#N/A	#N/A

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[CSyx]

azii,

I believe the first formula for Fatima should be: =index($C$2:$H$50,3,match($K$2,$C$2:$H$2,0)) assuming your data starts in Row 3. Fill down the formula, and then increase the row reference. So the next row should have the formula =index($C$2:$H$50,4,match($K$2,$C$2:$H$2,0)).

Hope this helps!