Lookup Date equal to or smaller than specified Date

You're welcome. Basically, the LOOKUP function [ LOOKUP(2,1/... ] returns the last value in column I that meets a certain criteria.

That criteria is: Bank!A3:A300=MAX(IF(Bank!A3:A300<=F7,Bank!A3:A300))

So it checks the last value in the range A3:A300 that is {=MAX(IF(Bank!A3:A300<=F7,Bank!A3:A300))} and returns the corresponding value (same row) in column I.

The MAX IF array formula finds the maximum value of A3:A300 that is less than or equal to the value in F7.

All dates have a numerical value associated with them (the number of days away from 1/0/1900) so the MAX IF formula finds the most recent date that is less than or equal to the date in F7.

Thanks 63falcondude...

Using the same spreadsheet and criteria, the above works perfectly at providing the value for the specified date. I now realise i will also need a formula to return a value when the specified date is first found (rather than last time as above). I've tried removing 2,1 etc.. but not getting the result. Could you point me in the right direction?

Thanks again..