I have a Poster wrksheet that has the heigt and width of all the posters. The
height is multiplied by the width to get the total square inches. I have
another wrksheet that has a table that includes a range of square inches and
then a price for each instance. For certain square inch totals there is more
than one possible price. On the poster wrksheet I want to lookup the square
inces for a poster on the price wrksheet and return all possible prices for
that size. Also, I don't want to display them all in one column but rather in
one row and I need the formula to round up to the next highest square inch
value in the price table if it is between two values.

e.g.

PRICE TABLE

Total Sq. Inches Price
92 2.00
100 2.10
135 2.50
145 3.00
145 3.20

POSTER TABLE

Poster Height Width Square Inches Price 1 Price 2
Price 3
D12RS 12 12 144 3.00 3.25
D45PP 10 10 100 2.10

Thanks for your help.