Auto-Calculate price based on width x height

[GuybrushThreep]

G'Day! I'm trying to create a excel sheet which will automatically calculate a price based on a given width or height. At the moment we calculate price by manually looking in a price book which has plenty of rows and columns and prices. I want to simplify this by simply entering the dimensions so it automatically calculates price based on the dimensions entered.

E.G.
you enter width of 1500mm in one field, then 900mm in another field, and next to that it automatically shows the price (based on some price list on another spreadsheet or workbook).

Any Help or Advice?
Cheers Mates!

 

[sheetspread]

Writing the upper and lower limit in each cell is less efficient than:

Book1.xlsm
	A	B	C	D
3		0	1001	1101
4		5	7	9
5
6
7	1087	7
Sheet1

Cell Formulas
Range	Formula
B7	B7	=HLOOKUP(A7,$B$3:$D$4,2)