Formulas to show Pounds Euros and dollars in three rows

[tonywatsonhelp]

hi Everyone,
thought this would be easy but i'm getting very long formulas and problems so please help if you can

Heres what i have

In

"V2" i select a currency they are written like this , Pound (£) , Euro (€) , Dollar ($)
in W2 i put the amount so 1000

In have exchange rates like this

	AA	AB	AC
Row 1	Pound (£)	Euro (€)	Dollar ($)
Pound (£)	1	0.9	0.7
Euro (€)	1.1	1	0.8
Dollar ($)	1.3	1.2	1	(the rates dont matter just for example)

so basicly i have all the exchange rates pound to euro/dollar ect.
now heres where i get confused
in J2 I want the pound amount,
K2 the Euro Amount
L2 The dolllar amount

i need formulas for these as i need to pull it down the page once it works

can anyone help?
if so please help as this is driving me made!

thanks

tony

 

[kweaver]

Is this right with Euro in V2 and 1000 in W2 ( used 1.21196 for AB4)?

Book25
	J	K	L
1	Pound	Euro	Dollar
2	900	1000	1211.96
Sheet5

Cell Formulas
Range	Formula
J2:L2	J2	=$W$2*VLOOKUP(J$1,$Z$1:$AC$4,1+MATCH($V$2,$AA$1:$AC$1,0),0)

 

[kweaver]

Book25
	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
1	Pound	Euro	Dollar															Pound	Euro	Dollar
2	870.55	1000	1210.35										Euro	1000			Pound	1	0.87055	0.71917
3																	Euro	1.1	1	0.8
4																	Dollar	0.71917	1.21035	1
Sheet5

Cell Formulas
Range	Formula
J2:L2	J2	=$W$2*VLOOKUP(J$1,$Z$1:$AC$4,1+MATCH($V$2,$AA$1:$AC$1,0),0)

 

[tonywatsonhelp]

thank you,
i'll have a test and see if i get the results i need
thanks