Cell Reference if two cells contain specific info

KWuis10

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!

Paul Newcome

It sounds like you are going to need an INDEX/COLLECT.

=INDEX(COLLECT({Price}, {Product}, @cell = [Product To Order]@row, {Size}, @cell = [Container Size]@row), 1)