Match number with mixed text num in Column

Forum Sample 27 Dec 09.xls
Hi Forum Friends
Please see the attachment.
I want to match the number in D4 to the numbers on the right in Column F21: F80, and put the offset result in E4.
The end result I need is as computed in E6, but without referring to a specific cell in the column.
Many Thanks
Al

Try:

=D4-MID(INDEX(F21:F80,MATCH(TRUE,INDEX(MID(F21:F80,9,100)=TEXT(D4,"0.000"),0),0)-1),9,100)

Note: For the first part Looks like you can use D4 directly instead of search for the same thing in the F2:F80 range...