I would add another column to the poster table that calculates the next
higher size if an exact size is not listed in the price table. Trust me,
this will make things much easier!

Here's a small sample file that demonstrates this:

poster_size_lookup.xls 14kb

http://cjoint.com/?bdeFaw26cM

The formulas (highlighted in yellow) in columns E:H are array formulas. They
need to be entered using the key combination of CTRL,SHIFT,ENTER (not just
ENTER). If you edit them they need to be re-entered as arrays using the key
combo.

Biff

"Spencer" wrote in message
...
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.