match a value and lookup for alternate row

[drkiran33]

hi,
I got the problem to look up a value and return a cell that is in next row.

1	1/1/11	1/7/11	1/1/12	1/7/12
	250	300	350	400
2	1/1/11	1/7/11	1/1/12	1/7/12
	256	248	259	458
3	1/1/11	1/7/11	1/1/12	1/7/12
	569	256	4566	124
4	1/1/11	1/7/11	1/1/12	1/7/12
	245	865	215	263

<tbody>
</tbody>

in sheet 2:-

1	250	300	350	400
2	256	248	259	458
3	569	256	4566	124
4	245	865	215	263

<tbody>
</tbody>

so,data arranged as in sheet 1 needs to arranged as in sheet 2,i.e.,excluding rows with dates and instead to return the below value.
I tried with this formula-=INDEX(Sheet1!C2:H2,MATCH(1,INDEX(--ISNUMBER(Sheet1!C2:H2),0),0))
but problem is my required data is arranged in altenates and i cant get it.

Any help is much valued..

 

[GabrielMM]

Can you just filter all "date" values and then delete them?

 

[drkiran33]

s,it can be done,but my sheet is having another data also,so it needs only to match the number and to pick only the cell required in example.that is the problem.