0

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

Alvin Wong
  • 23
  • 1
  • 5
  • @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 Oct 06 '17 at 16:12
  • correct, my second table has all the possible combinations (100 rows) of exchange rates. (ie AUD to EUR, SAR to GBP, etc.) – Alvin Wong Oct 06 '17 at 16:17

1 Answers1

2

Use

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

enter image description here

Scott Craner
  • 148,073
  • 10
  • 49
  • 81