How to convert price in EUR from a column with many currencies values and N/A values?

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.

Originally Posted by Luu4466

Can you help to find a formula where i can find the value in € automatically?

what does this refer to?

Don't worry. I found a easier solution, maybe longer, but i found it. Thank you for your help.