Excel Formula to calculate currency exchange rates based on Fixed Rate Table

0
votes

I have a fixed currency exchange rate table (columns A to C) for 10 different currencies to CAD in Excel as follows:

Fixed Rates to CAD

I would like to know if there is a formula that I can use under Column H to populate all the different combinations of currencies and give me the exchange rates based on the table mentioned above:

All combinations

1
excelcurrency-exchange-rates
@ScottCraner, he may not just want the VLOOKUP. I guess what he wants is to have all the conversion rates computed based on the first table. So USD to BBD will need to use USD to CAD and BBD to CAD columns to do it. – ian0411
correct, my second table has all the possible combinations (100 rows) of exchange rates. (ie AUD to EUR, SAR to GBP, etc.) – Alvin Wong

1 Answers

2
votes

Use

=SUMIF(A:A,E2,C:C)/SUMIF(A:A,F2,C:C)

enter image description here