# Finding value using greater than, Vlookup, and nested If

W

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.

S

#### Sixthsense

Try this…

Copy and paste the below formula in any of the 3rd row cell and drag
it below.

=IF(ISNA(VLOOKUP(\$A3,'sold 1'!C\$2:F\$1201,4,FALSE)),"Data Not
Found",IF(VLOOKUP(\$A3,'sold 1'!C\$2:F
\$1201,4,FALSE)>=(\$D3+24),VLOOKUP(\$A3,'sold 1'!C\$2:F
\$1201,4,FALSE),"Resulting Value Is Less Than the Column D+24 Value "))

Or

=IF(ISNA(VLOOKUP(\$A3,'sold 1'!C\$2:F\$1201,4,FALSE)),"Data Not
Found",IF(VLOOKUP(\$A3,'sold 1'!C\$2:F
\$1201,4,FALSE)>=(\$D3+24),VLOOKUP(\$A3,'sold 1'!C\$2:F
\$1201,4,FALSE),"Resulting Value Is Less Than the D"&ROW(A3)&"+24
Value"))

Or

=IF(ISNA(VLOOKUP(\$A3,'sold 1'!C\$2:F\$1201,4,FALSE)),"Data Not
Found",IF(VLOOKUP(\$A3,'sold 1'!C\$2:F
\$1201,4,FALSE)>=(\$D3+24),VLOOKUP(\$A3,'sold 1'!C\$2:F
\$1201,4,FALSE),"Resulting Value Is Less Than the D"&ROW(A3)&"+24 Value
{"&VLOOKUP(\$A3,'sold 1'!C\$2:F\$1201,4,FALSE)&"<"&\$D3+24&"}"))

Hope that helps!

W