Hi community!
I work in the sheet "Raw data". I want to find the price in € in my column H based on the values in column F.
Capture.PNG
The value in my column F are N/A values or values with local currency.
That's why I use a converter table.
Capture2.PNG
Can you help to find a formula where i can find the value in € automatically?
Thank you for your help.
Bookmarks