Index formula help?

[Carlbacca]

I have this formula where it looks in a table to match three different criteria in a row before it pulls through some data in that row. the formula is:

INDEX(H:H,MATCH(1,(B:B=B17288)*(E:E=E17288)*(F:F=F17288)* ( ( $C$1:C17287 < C17288 ) - ( $C$1 : C17287 < ( C17288 - 41 ))),0)))
<C17288)-($C$1:C17287<(C17288-41< font>
<?XML:NAMESPACE PREFIX = C17288)-($C$1 /><C17288)-($C$1:C17287<(C17288-41))),< font></C17288)-($C$1:C17287<(C17288-41))),<>
<C17288)-($C$1:C17287<(C17288-41))),< font><C17288)-($C$1:C17287<(C17288-41)< font><C17288)-($C$1:C17287<(C17288-41))),< font>
The part highlighted in red is looking for a criteria between two dates, can anybody tell me if there is anything else I can use in this formula to search the latest date and not a date between two dates?

Any help will be appreciated.

Thanks
</C17288)-($C$1:C17287<(C17288-41))),<>
</C17288)-($C$1:C17287<(C17288-41))),<>
</C17288)-($C$1:C17287<(C17288-41)<>

</C17288)-($C$1:C17287<(C17288-41<>