Set price table (A1:C3) as below: B1, C1 have widths, A2,A3 have heights


0 2751
0 100 300
1501 250 450

in H20:

=INDEX($A$1:$C$3,MATCH($C$20,$A$1:$A$3,1),MATCH($A $20,$A$1:$C$1,1))


If increments are 300, then your table "headings" will look like:

0 301 601 901 ......
0

301

601

901

etc

HTH

"G''''David F" wrote:

As above, I am trying to return (A) price value (within one cell) from values
contained in a table (which has widths running across the rows, heights
running down the columns. AND has values in 100's by the cell) based on
dimension values in two separate cells...
The format of the table values will not allow me to calculate the price
based on square metres or feet, but relies on arbitrary increments.
Furthermore, the dimension values in width are in Millimetres and the table
"Width" price changes in increments of 300 (17 options in Width prices. Too
many for IF function?)
Dimension value for height are in Milimetres and the table "Height" price
changes in increments of 300 also (8 options in Height prices)

SO;
Sheet 1 contains;

(@A20) WIDTH(0-5500, no decimal places)
(@C20) HEIGHT(0-3000, no decimal places)

(@H20) PRICE I want to insert rather than manually find from a
table..(formatted as currency)

Sheet 2 contains;
(Pricing table) lets say 2 by 2 price options to look up from table;
(@B2) (WIDTH to 2750, HEIGHT to 1500) price = 100
(@C2) (WIDTH to 5500, HEIGHT to 1500) price = 300
(@B3) (WIDTH to 2750, HEIGHT to 3000) price = 250
(@C3) (WIDTH to 5500, HEIGHT to 3000) price = 450

I would use the IF logic, but there are too many options (136 to be precise)
as stated but wonder if there is a way to return these values automatically.
As a self taught noob I am at a loss, hence my posting here for help with
this one...
Anyone?
Regards,
David