Table Lookup
 

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

Table Lookup
 

=INDEX($A$1:$E$5,MATCH(Curr1,$A:$A,False),MATCH(Cu rr2,$1:$1,False))

HTH,
Bernie
MS Excel MVP


"Andrew Mackenzie" wrote in message
...
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

Table Lookup
 

Place rate table anywhere in your workbook, name it, say, "exchange", then in
C1:
=INDEX(exchange,MATCH(A1,INDEX(exchange,,1,1),0),M ATCH(B1,INDEX(exchange,1,,1),0))

Regards,
Stefi

€žAndrew Mackenzie€� ezt Ã*rta:

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

Table Lookup
 

Thanks Berni & Stefi,

Much appreciated,

Andrew
"Stefi" wrote in message
...
Place rate table anywhere in your workbook, name it, say, "exchange", then
in
C1:

=INDEX(exchange,MATCH(A1,INDEX(exchange,,1,1),0),M ATCH(B1,INDEX(exchange,1,,
1),0))

Regards,
Stefi

"Andrew Mackenzie" ezt írta:

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

Table Lookup
 

You are welcome! Thanks for the feedback!
Stefi
Clicking the YES button will be appreciated.

€žAndrew Mackenzie€� ezt Ã*rta:

Thanks Berni & Stefi,

Much appreciated,

Andrew
"Stefi" wrote in message
...
Place rate table anywhere in your workbook, name it, say, "exchange", then
in
C1:

=INDEX(exchange,MATCH(A1,INDEX(exchange,,1,1),0),M ATCH(B1,INDEX(exchange,1,,
1),0))

Regards,
Stefi

"Andrew Mackenzie" ezt Ã*rta:

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