Finding value using greater than, Vlookup, and nested If


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.
 
Ad

Advertisements

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!
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top