.....i want the new speed from speed rating (down) to be in flat file-(down)
column D. i did the first but i don't know whether it is correct or wrong???
and i want the features 2 from speed rating(down) to be in flat file (down)
column E in the exact position....

note: i don't want the flat file-(down) Column D to be empty or with 0 as
there some of the row are not fill with number from speed rating (down).

Speed rating down sheet 1

column A -start km
Column B-End Km
Column C- current speed
Column D- Features
Column E-New Speed
Column F-Feature

Sheet 2 Down

Column A-start Km from 0.1km to 42km
Column B -line number= i use the match function =match(start km in sheet
2,end km in sheet 1,1)
Column C-current speed- i use=if(offset(current speed in sheet 1,line number
in sheet 2,0)="",90,offset(current speed in sheet 1,line number in sheet 2,0))
Column D-new speed- this is the column i use=offset(sheet 1 new speed,line
number in sheet 2,0)===i got problem with this...i want to offset exact
match but if the sheet 1 new speed is empty with some row it return 0, i want
something to return instead of 0......

in sheet 2 column E, I want feature from sheet 1 to match with the exact in
sheet 2....How can i do that...the feature column is mixed with words and
values