Conversion of currencies

Mark Tserkezie

Help please!! I have a sheet that has a column with currency code and conversion rate. On another sheet I want it so that local currency value can be used, the appropriate currency code selected and then next column should auto convert to GBP for reporting purposes.

Can you help me to create this please?

Bassam Khalil

Hi @Mark Tserkezie

Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Mark Tserkezie

Thanks in advance

Bassam Khalil

Hi @Mark Tserkezie

Hope you are fine, please use the following formula

=IFERROR((INDEX({FY21 Rate}, MATCH(Currency@row, {Currency type}), 2)) * [Total Annual Premium (Local Currency)]@row, "")

the following screenshot shows the result