A
Andrew Mackenzie
Would appreciate any help offered here.
I have a table of exchange rates something like this:
USD GBP CHF JPY
USD 1.00 1.62 0.94 0.01
GBP 1.62 1.00 1.72 150.0
CHF 0.94 1.72 1.00 0.01
JPY 0.01 150.0 0.01 1.00
In column A I have one currency and in column B I have another. In column C
I want to lookup the appropriate exchange rate from the table. I assume
that this is some sort of Index Match type lookup but can't get my head
around the formula.
As I said I would be grateful for any assistance here.
Many thanks,
Andrew
I have a table of exchange rates something like this:
USD GBP CHF JPY
USD 1.00 1.62 0.94 0.01
GBP 1.62 1.00 1.72 150.0
CHF 0.94 1.72 1.00 0.01
JPY 0.01 150.0 0.01 1.00
In column A I have one currency and in column B I have another. In column C
I want to lookup the appropriate exchange rate from the table. I assume
that this is some sort of Index Match type lookup but can't get my head
around the formula.
As I said I would be grateful for any assistance here.
Many thanks,
Andrew