IF formula for 3 calculations based on the contents of Column D

[simonharry]

Hi All,

Hope you are well.

I would like some help on an IF statement please.

In column D, I have the following values...EUR, GBP and USD.

I need a formula which calculates based on the contents of the cell in column D.

My formulas for the calcs are.

EUR - =SUM('Raw Data'!E2/Menu!$J$4)/'Raw Data'!B2*B2)
USD - as above but $J$5
GBP - as above but $J$6

Thanks

 

[Special-K99]

=SUM('Raw Data'!E2/INDEX(Menu!$J$4:J$6,LOOKUP(D1,{"EUR","GBP","USD"},{1,3,2}),1))/'Raw Data'!B2*B2)

change D1 to what it should be (as you havent specified what row the currencies in column D start on)

 

[simonharry]

Magnificent. Thanks so much.