I have a row with 10 different escalating numbers (in numerical order lowest to highest). Example: Cell B1=10, C1=20, D1=30, etc.
If I have a value in A1 of 21.4, I want to do a lookup in that row for the number higher than 21.4 (which would be 30) and dump the number 30 into cell A2.
I have tried hlookup and it works fine except it returns a number LOWER than the value I input rather than HIGHER. How can I modify the hlookup command to return the higher value which will ALWYS be one cell or column to the right?