Finding value using greater than, Vlookup, and nested If

  • Thread starter Thread starter waddsn1060
  • Start date Start date
W

waddsn1060

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.
 
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!
 
Back
Top