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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]1/1/11[/TD]
[TD]1/7/11[/TD]
[TD]1/1/12[/TD]
[TD]1/7/12[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]250[/TD]
[TD]300[/TD]
[TD]350[/TD]
[TD]400[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1/1/11[/TD]
[TD]1/7/11[/TD]
[TD]1/1/12[/TD]
[TD]1/7/12[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]256[/TD]
[TD]248[/TD]
[TD]259[/TD]
[TD]458[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1/1/11[/TD]
[TD]1/7/11[/TD]
[TD]1/1/12[/TD]
[TD]1/7/12[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]569[/TD]
[TD]256[/TD]
[TD]4566[/TD]
[TD]124[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1/1/11[/TD]
[TD]1/7/11[/TD]
[TD]1/1/12[/TD]
[TD]1/7/12[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]245[/TD]
[TD]865[/TD]
[TD]215[/TD]
[TD]263[/TD]
[/TR]
</tbody>[/TABLE]

in sheet 2:-
[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]250[/TD]
[TD]300[/TD]
[TD]350[/TD]
[TD]400[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]256[/TD]
[TD]248[/TD]
[TD]259[/TD]
[TD]458[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]569[/TD]
[TD]256[/TD]
[TD]4566[/TD]
[TD]124[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]245[/TD]
[TD]865[/TD]
[TD]215[/TD]
[TD]263[/TD]
[/TR]
</tbody>[/TABLE]

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.