Cell Reference if two cells contain specific info

Options

I am trying to create some automation for invoicing and am running into an issue finding the right formula for cross sheet referencing.

I have a product sheet with pricing and then have individual client order sheets. I want to return the price from the product sheet based on criteria in a "Product to Order" and "Container Size" columns. Ex: If Product is X and Container Size is X, return price for that order size from reference sheet.

HELP!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!