autofill cells by entering date

[azii]

Hello there
I am trying to solve this issue but I am stuck. I need help to resolve this problem
I have data In table-1 and I have to enter date and get the data datewise in table-2, I have 3 heads in table-2 i.e. Fatima, Engro and Sona/ffc
table-2 is showing position.
I am using this formula
=IF($K$2=$D$2,INDEX($B$2:$I$50,3,3),IF($K$2=$E$2,INDEX($B$2:$I$50,3,4),IF($K$2=$F$2,INDEX($B$2:$I$50,3,5),IF($K$2=$G$2,INDEX($B$2:$I$50,3,6),IF($K$2=$H$2,INDEX($B$2:$I$50,3,7),IF($K$2=$D$2,INDEX($B$2:$I$50,3,8),""))))))
but I can't follow this formula because I would have more data spreading horizontally (e.g. A to Z and so on...)
please help me.


TABLE-1

	A	B	C	D	E	F	G	H
1	Receiving Date		16-Nov-12	26-Nov-12	27-Dec-12	28-Feb-13	5-Mar-13	22-Mar-13
2	Parameters	Unit	Fatima	Fatima	Fatima	Fatima	Fatima	Fatima
3	Moisture	%	0.18	0.11	0.14	0.25	0.22	0.21
4	Biuret	%	0.97	0.97	1.12	1.03	0.91	1
5	Mesh Size
6	+2.80 mm	%	2.5	6.5	2.1	2.0	5.7	3.8
7	+2.40 mm	%	16.4	17.5	14.0	13.6	17.7	20.4
8	+2.00 mm	%	46.7	39.4	46.7	45.8	40.2	44.1
9	+1.70 mm	%	25.3	31.1	29.0	24.3	24.1	24.5
10	+1.40 mm	%	5.6	4.5	5.2	8.0	7.0	5.0
11	+1.00 mm	%	2.5	0.9	1.5	4.3	2.5	1.4
12	+0.50 mm	%	0.8	0.1	0.8	1.7	1.9	0.7
13	-0.50 mm	%	0.2	0	0.7	0.3	0.9	0.1
14	1 ~ 2.4 mm	%	96.5	93.4	96.4	96.0	91.5	95.5
15	Fines	%	1.0	0.1	1.5	2.0	2.8	0.8
16	Avg. Prill Size	mm	2.11	2.17	2.09	2.05	2.11	2.16
17	Avg. Crush Strength	Grams	807	1291	806	806	802	817
18	Parameters	Unit	Engro	Engro	Engro	Engro	Engro	Engro
19	Moisture	%	0.21	0.14	0.22	0.32	0.24	0.27
20	Biuret	%	1.03	0.8	0.99	1.19	0.94	1.02
21	Mesh Size
22	+2.80 mm	%	5.5	79.1	4.6	0.9	6.3	5.8
23	+2.40 mm	%	14.6	14.7	13.3	9.0	17.3	17.1
24	+2.00 mm	%	34.2	4.7	34.2	28.4	36.1	32.3
25	+1.70 mm	%	35.0	4.4	36.4	50.3	29.6	37.1
26	+1.40 mm	%	8.4	0.3	9.4	6.0	8.5	6.0
27	+1.00 mm	%	1.6	0.1	1.6	2.6	1.5	1.0
28	+0.50 mm	%	0.5	0	0.4	1.8	0.5	0.6
29	-0.50 mm	%	0.2	0	0.1	1.0	0.2	0.1
30	1 ~ 2.4 mm	%	93.8	20.9	94.9	96.3	93.0	93.5
31	Fines	%	0.7	0	0.5	2.8	0.7	0.7
32	Avg. Prill Size	mm	2.09	2.94	2.07	1.95	2.13	2.1
33	Avg. Crush Strength	Grams	819	4645	804	801	806	812.0
34	Parameters	Unit	Sona/ffc	Sona/ffc	Sona/ffc	Sona/ffc	Sona/ffc	Sona/ffc
35	Moisture	%	0.10	0.19	0.16	0.22	0.29	0.24
36	Biuret	%	0.88	0.96	0.91	0.91	0.92	0.9
37	Mesh Size
38	+2.80 mm	%	5.7	3	3.9	7.8	5.3	3.3
39	+2.40 mm	%	15.9	14.5	10.3	18.7	17.9	10.6
40	+2.00 mm	%	31.9	60.8	70.0	52.0	41.1	62.8
41	+1.70 mm	%	34.7	18.8	13.1	13.0	25.4	20.2
42	+1.40 mm	%	9.6	1.9	1.6	4.9	7.2	1.8
43	+1.00 mm	%	1.5	0.9	0.7	2.4	2.1	0.8
44	+0.50 mm	%	0.5	0.1	0.3	1.1	0.9	0.4
45	-0.50 mm	%	0.2	0	0.1	0.1	0.1	0.1
46	1 ~ 2.4 mm	%	93.6	96.9	95.7	91.0	93.7	96.2
47	Fines	%	0.7	0.1	0.4	1.2	1.0	0.5
48	Avg. Prill Size	mm	2.09	2.18	2.19	2.21	2.14	2.16
49	Avg. Crush Strength	Grams	814	951	821	822	808	819

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

TABLE-2

5-Mar-13
Fatima	Engro	Sona/ffc
0.22	0.24	0.92
0.91	0.94	0.94
-	-	-
5.7	6.3	6.3
17.7	0.2	0.2
40.2	36.1	36.1
24.1	29.6	29.6
7	8.5	8.5
2.5	1.5	1.5
1.9	0.5	0.5
0.9	0.2	0.2
91.5	93	93
2.8	0.7	0.7
2.11	2.13	2.13
802	806	806

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[Andrew Poulsom]

My formula didn't use OFFSET:

=INDEX(INDEX($C$2:$H$49,0,MATCH($K$1,$C$1:$H$1,FALSE)),MATCH(K$2,$C$2:$C$49,FALSE)+ROWS(K$3:K3))