Forum Discussion
Vlookup?
Hi! Anyone know how to make vlookup not just return a value from a column, but to compare if it is equal or bigger to another value before returning the result?
You could use it in an IF statement:
=IF(VLookup(...)>=Value, VLookup(...), False)
In this example, I have the IF statement just returning False if the returned value is <= the value you're testing it against. But, you can change that to whatever you want, such as 0, "", etc.
If, by chance, you want the cell value to be the value you're testing for when the returned value is < said value, then you might also use the MIN function:
=MIN(VLookup(...), OtherValue)