Question in Expression

aditya_glp · 10-10-2019 10:44 PM

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.

aditya_glp

@Aleksi @Steve

Currently I’m using this formula which is not yielding any results–

LOOKUP(“CONCATENATE([Product - 1],”.",[Country])",“Products”,“CONCATENATE([Product Name],”.",[Country])",“Price”)

Steve