Vlookup,Hlookup, Data Validation and a Pricelist. Help!

[Margbot]

Hello,

I am hoping someone is able to help me on here. I am going to try to explain what I am trying to
do as best as possible. I have a pricelist that is based on the width and height of a product. Wherever the width and height meet is where the price is located. I am trying to come up with some sort of form on excel in which I can choose the height from one drop down list, the width from another, and have it give me the price (after it has looked for the intersecting cells from the spreadsheet). I have found various videos citing hlookup and vlookup but none that state if it is possible to use them together or how that would work. I am not an advanced user of excel so I am at a bit of a loss here.

Thank you so much for any help! I hope my explanation made sense.

 

[L. Howard]

Per your screen shot

In D1 enter =INDEX(C4:O17,MATCH(A1,B4:B17,0),MATCH(B1,C3:O3,0))
In A1 a drop down with the Heights
In B1 a drop down with the Widths

Regards,
Howard