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?
If you wish to exclude small values from the search, you could remove terms from the lookup array. That would allow the look up to pass over invalid records and return a later match or, if that is not present, use the error to trigger an entirely different formula.
= XLOOKUP(Selected, IF(Value>threshold, Name), Value, "Not found")