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
Hi everyone,
I am doing some excel analysis for a university assignment, and I would be very grateful of any help on a problem I have.
The analysis basically has 2 data components to it:
The 1st part, is a basic transaction list of shopping items bought through the year. Each transaction's...