Calc on Pivot Table

I have a 4 x 4 table.

the table looks like this from A1:D4

USD EUR GBP
USD 1.0 1.19 1.73
EUR 0.83 1.0 1.45
GBP 0.57 0.68 1.0

In cell G1 I have a cell where I enter USD or EUR or GBP

In cell F12 I have a cell where I enter USD or EUR or GBP

In cell G12 I enter a number.

I need a formula for cell H12 that will multiply the cell in G12 times the
correct cell in the pivot table based on G1 and F12.

For example if G1=USD and F12=USD then G12 should be multiplied times B2.

what I am trying to do is create a simple report that calculates an expense
item in one currency to a report base currency.

Thanks for any help provided.

I can't tell from your example if you want to reference column or row first
(USD to USD is 1.0 whether you are going row to col or col to row)

however something like:

=OFFSET(A1,MATCH(G1,A2:A4,0),MATCH(F12,B1:D1,0))*G12

works for me.

Incoherent

"Frick" wrote:

> I have a 4 x 4 table.
>
> the table looks like this from A1:D4
>
> USD EUR GBP
> USD 1.0 1.19 1.73
> EUR 0.83 1.0 1.45
> GBP 0.57 0.68 1.0
>
> In cell G1 I have a cell where I enter USD or EUR or GBP
>
> In cell F12 I have a cell where I enter USD or EUR or GBP
>
> In cell G12 I enter a number.
>
> I need a formula for cell H12 that will multiply the cell in G12 times the
> correct cell in the pivot table based on G1 and F12.
>
> For example if G1=USD and F12=USD then G12 should be multiplied times B2.
>
> what I am trying to do is create a simple report that calculates an expense
> item in one currency to a report base currency.
>
> Thanks for any help provided.
>
>
>