Thread: Finding first value that is greater than value

I am trying to use VLOOKUP to return a value only if it greater than
or equal to a value on current sheet. Here is what I have:

=IF(ISNA(VLOOKUP($A3,’sold 1’!C$2:F$1201,4,FALSE))>=(D3+24),
(VLOOKUP($A3,'sold 1'!C$2:F$1201,4,FALSE)))

Currently it only pulls the first value it finds in column 4 of the
table array that matches the lookup value but I want it to return the
first value it finds in column 4 that matches the lookup value that is
greater than or equal to cell D3+24.

need an example speardsheet to better understand

I am trying to populate column L with the first date for that record # that occurs >= 24 days after column C thats on the tab sold 1.