Calculate price based on panel width x height from price graph

[Hossman]

Hello everyone,

Needing some assistance on creating a graph that will calculate a priced based on a board dimensions (height x width), but the graph is base on in-between lengths (see below)

I found this link but, not quite what im after, any help would be great https://www.mrexcel.com/forum/excel-questions/562186-auto-calculate-price-based-width-x-height.html

[TABLE="width: 1197"]
<tbody>[TR]
[TD][/TD]
[TD="colspan: 2"]Board Dimensions[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Height (mm)[/TD]
[TD]Width (mm)[/TD]
[TD]Price $[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]400[/TD]
[TD]150[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 12"]WIDTH (mm)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]35 - 150[/TD]
[TD]151 - 300[/TD]
[TD]301 - 350[/TD]
[TD]351 - 400[/TD]
[TD]401 - 450[/TD]
[TD]451 - 500[/TD]
[TD]501 - 550[/TD]
[TD]551 - 600[/TD]
[TD]601 - 650[/TD]
[TD]651 - 800[/TD]
[TD]801 - 1000[/TD]
[TD]1001 - 1200[/TD]
[/TR]
[TR]
[TD]HEIGHT (mm)[/TD]
[TD]32 -200[/TD]
[TD]$15.87[/TD]
[TD]$18.72[/TD]
[TD]$19.66[/TD]
[TD]$20.63[/TD]
[TD]$21.58[/TD]
[TD]$22.53[/TD]
[TD]$23.48[/TD]
[TD]$24.44[/TD]
[TD]$25.37[/TD]
[TD]$28.23[/TD]
[TD]$32.03[/TD]
[TD]$35.83[/TD]
[/TR]
[TR]
[TD]201 - 400[/TD]
[TD]$18.95[/TD]
[TD]$24.00[/TD]
[TD]$25.68[/TD]
[TD]$27.36[/TD]
[TD]$29.05[/TD]
[TD]$30.74[/TD]
[TD]$32.40[/TD]
[TD]$34.09[/TD]
[TD]$35.76[/TD]
[TD]$40.82[/TD]
[TD]$47.56[/TD]
[TD]$54.26[/TD]
[/TR]
[TR]
[TD]401 - 600[/TD]
[TD]$22.01[/TD]
[TD]$29.26[/TD]
[TD]$31.67[/TD]
[TD]$34.09[/TD]
[TD]$36.49[/TD]
[TD]$38.91[/TD]
[TD]$41.34[/TD]
[TD]$43.73[/TD]
[TD]$46.16[/TD]
[TD]$53.42[/TD]
[TD]$63.05[/TD]
[TD]$72.71[/TD]
[/TR]
[TR]
[TD]601 - 750[/TD]
[TD]$24.31[/TD]
[TD]$33.21[/TD]
[TD]$36.16[/TD]
[TD]$39.15[/TD]
[TD]$42.10[/TD]
[TD]$45.04[/TD]
[TD]$48.02[/TD]
[TD]$50.97[/TD]
[TD]$53.95[/TD]
[TD]$62.83[/TD]
[TD]$74.68[/TD]
[TD]$86.54[/TD]
[/TR]
[TR]
[TD]751 - 900[/TD]
[TD]$26.64[/TD]
[TD]$37.16[/TD]
[TD]$40.65[/TD]
[TD]$44.20[/TD]
[TD]$47.69[/TD]
[TD]$51.22[/TD]
[TD]$54.71[/TD]
[TD]$58.24[/TD]
[TD]$61.74[/TD]
[TD]$72.28[/TD]
[TD]$86.31[/TD]
[TD]$100.35[/TD]
[/TR]
[TR]
[TD]901 - 1200[/TD]
[TD]$31.24[/TD]
[TD]$45.04[/TD]
[TD]$49.68[/TD]
[TD]$54.26[/TD]
[TD]$58.87[/TD]
[TD]$63.50[/TD]
[TD]$68.11[/TD]
[TD]$72.71[/TD]
[TD]$77.31[/TD]
[TD]$91.16[/TD]
[TD]$109.58[/TD]
[TD]$128.02[/TD]
[/TR]
[TR]
[TD]1201- 1500[/TD]
[TD]$35.83[/TD]
[TD]$52.96[/TD]
[TD]$58.67[/TD]
[TD]$64.36[/TD]
[TD]$70.06[/TD]
[TD]$75.78[/TD]
[TD]$81.47[/TD]
[TD]$87.20[/TD]
[TD]$92.90[/TD]
[TD]$110.01[/TD]
[TD]$132.83[/TD]
[TD]$155.66[/TD]
[/TR]
[TR]
[TD]1501 - 1800[/TD]
[TD]$40.46[/TD]
[TD]$60.86[/TD]
[TD]$67.67[/TD]
[TD]$74.46[/TD]
[TD]$81.28[/TD]
[TD]$88.08[/TD]
[TD]$94.87[/TD]
[TD]$101.68[/TD]
[TD]$108.49[/TD]
[TD]$128.89[/TD]
[TD]$156.10[/TD]
[TD]$213.52[/TD]
[/TR]
[TR]
[TD]1801 - 2100[/TD]
[TD]$45.04[/TD]
[TD]$68.76[/TD]
[TD]$76.64[/TD]
[TD]$84.56[/TD]
[TD]$92.46[/TD]
[TD]$100.35[/TD]
[TD]$108.25[/TD]
[TD]$116.16[/TD]
[TD]$124.06[/TD]
[TD]$147.76[/TD]
[TD]$179.34[/TD]
[TD]$243.93[/TD]
[/TR]
[TR]
[TD]2101 - 2400[/TD]
[TD]$49.68[/TD]
[TD]$76.64[/TD]
[TD]$85.68[/TD]
[TD]$94.65[/TD]
[TD]$103.64[/TD]
[TD]$112.64[/TD]
[TD]$121.64[/TD]
[TD]$130.65[/TD]
[TD]$139.64[/TD]
[TD]$166.61[/TD]
[TD]$202.62[/TD]
[TD]$274.34[/TD]
[/TR]
[TR]
[TD]2401 - 2700[/TD]
[TD]$57.07[/TD]
[TD]$89.08[/TD]
[TD]$99.80[/TD]
[TD]$110.45[/TD]
[TD]$121.14[/TD]
[TD]$131.82[/TD]
[TD]$142.48[/TD]
[TD]$153.18[/TD]
[TD]$163.84[/TD]
[TD]$195.88[/TD]
[TD]$238.61[/TD]
[TD]$317.05[/TD]
[/TR]
[TR]
[TD]2701 - 3050[/TD]
[TD]$67.53[/TD]
[TD]$106.78[/TD]
[TD]$119.91[/TD]
[TD]$132.98[/TD]
[TD]$146.07[/TD]
[TD]$159.18[/TD]
[TD]$172.27[/TD]
[TD]$185.36[/TD]
[TD]$198.45[/TD]
[TD]$237.73[/TD]
[TD]$290.10[/TD]
[TD]$378.21[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1161"]
<tbody>[TR]
[TD="colspan: 2"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]