Hlookup - How do I return the next highest value?

Posted by Jim on March 27, 2000 9:22 AM

I am having trouble returning the next highest value using HLOOKUP.

For example:

My table array (data) = 10, 20, 30, 40, 50

If my lookup value is 34, HLookup returns 30. I would like it to return 40 (round up instead of down).

Any help would be greatly appreciated

Posted by AB on March 28, 2000 6:30 AM

For your example, just add 10 to the lookup value.