Hi,

You might be better served by using index and match. I presume that on the "Kitchen Prices" tab there is a table of width, height and price of the doors?

If so, you could use

=INDEX(table_of_prices,MATCH(A2,Range of widths,0),MATCH(B2,range_of_heights,0))