Make two drop down choices give me the answer from another sheet

[KristophB]

On one sheet, I have the option to select the length and width of a product, in hopes that it will give me the cost from the other sheet of prices once I select both. I attached pictures to show, and I’m sorry if I’m not being clear enough. Any help would be greatly appreciated.

[KristophB]

[JohnSUN]

Welcome!

Get value of intersection from an array

Or =OFFSET(<first cell>;MATCH(..);MATCH()) or =INDEX(<array>;MATCH(..);MATCH()) Update. stuff_formulas.ods (12.0 KB)

[KristophB]

Thank you John, still learning here but you have saved me alot of stress! thanks for the soloution.