Hi,

I am trying to get Excel to look up a certain value from a small table
of values and have tried using the VLOOKUP/HLOOKUP functions but can't
get them to do exactly what I want. Here is how the spreadsheet looks:

Recommended Tank Size: 4400 litres

Range of Tank Sizes Available (litres):
1000, 2000, 3000, 4000, 5000, 6000, 7000, 8000, 9000, 10000

Basically their is an algorithm which calculates the "Recommended Tank
Size" and then Excel is supposed to look up the nearest but next
-largest- value from the "Range of Tank Sizes Available" table.

The problem I am having is that the VLOOKUP/HLOOKUP function only
returns the next -smallest- value. This seems to be a hard coded
feature and I can't change it. I also tried listing the tank sizes in
reverse (descending) order but this just produces and error.

Can anyone think of a way to get Excel to look up the next largest
figure from the data table rather than the nearest smallest?

Cheers
-Rob


--
TheRobsterUK


------------------------------------------------------------------------
TheRobsterUK's Profile: http://www.excelforum.com/member.php...fo&userid=9924
View this thread: http://www.excelforum.com/showthread...hreadid=373860