Let A house dates of interest and B the data associated with dates in A.On 2002-07-05 07:00, SummerStudent wrote:
I could use some help on this one. I need to construct a formula that scans a range of cells containing dates (eg. 29-Jun) and returns data corresponding to the closest date in the range.
Let E1 house a criterion/condition date.
would suffice, unless you mean something different with "closest date".
You can also replace A:A and B:B by definite ranges like A2:A10 and B2:B10.