I am familiar with VLOOKUP in general, but am having trouble figuring out if/how to make the ‘searchcriterion’ value use ‘is greater than’. In other words, I don’t want to lookup a value equal to a cell value, I want to lookup a value that is greater than the ‘searchcriterion’ cell value. Intuitively I tried adding the “>” before the cell reference, but that does not work.
FYI, my lookup array values are in ascending order.
Is it possible to achieve this in some way?