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.
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |