Accessing column without a primary key

[aditya_glp]

Hi all,

I have 2 sheets in my backend - Orders & Products .

My Product sheet has only 3 columns - Product Name, Country & Price.

In Orders sheet, I’m storing the response of a form where I take ‘country’ and ‘product’ as an input. Now based on this input, I want to get the price of the product for the input country.

Please help me to write an expression to get the price of the correct product. Please note that the price of a product is unique for a ‘country-product’ pair. A same product is of a different price in different countries…

I have already used Lookup & Select but not getting desired result. Kinldy help!