I am trying to prepare order form.
What should I do to achieve the final result that I describe below? I tried to use the IF function, but I think I am doing something very wrong. Please help. I hope that I can clarify my problem.
Here you can find my sample Google Sheet with a sketch of Order Form showing the situation. https://docs.google.com/spreadsheets/d/1sGpIl8PoPEcezU0NQpEn3FzWKxxeOe5q0O0JpM7jTX0/edit?usp=sharing
Description of the expected end result:
The end result is to be an automatic appearance of the price in the
cell after the two variables selected.
In the form, the variables are products and currency.
The user chooses one of three currencies and then selects the product. After that, in the
cell next to the product name, the price in the previously selected currency appears.
There is space to enter 10 products in the form, so the function (or script) should refer to 10 different
Sheet1 you can find the Order Form and you can choose the product and the currency.
Sheet2 you can find the products names and prices in three columns for three currencies.
The product column is called
Columns with currencies have names in order:
Thank you in advance for your help.