Here is a formula in a spreadsheet: =LOOKUP(1001,$I2:$I32,D2:D32)

The intent is to return the value in column D, a date, when the value in column I, a number, equals (or exceeds) the value 1000. I tried both 1000 and 1001 and get the same result.

The formula returns the column D value as a number (which requires that the cell be formatted as a date) from the row

*the column I value equals or exceeds 1001. Column I contains a value less than 1000 in the spreadsheet, but the next row value exceeds 1000.*

**before**Can someone please explain this for me? I've read several articles but none shed light on the issue for me.