Hi all,
I have a simple price grid: The rows are by "height" and the columns are by "width". If some one enters a height and a width in two seperate cells, I want another cell to find the proper cross reference cell (price). I am using an Index formula and it works ok except one thing: My height and width numbers in the price grid are incremental, its like this:
_________________________________________________
Width: 39 54 78 90 118
Height:
36 $20 $36 $52
48 $24 $38 $59
60 $27 $43
72
84
_________________________________________________
So if a user enters a width of 42 and a height of 42, I want the price returned to be $38 (in other words rounded up to the next cell). If I use a typical Index/Match formula and enter the match_type as 1, it would return $20, not $38.

How can I get my index formula to push the result up to the next grid position (or round up)?

Here is the formula I have been using:
=INDEX(Flocke,MATCH(F6,E17:E27,1),MATCH(F5,F15:M15,1))



Thanks!