Currency Converter Applying to Data

[pure vito]

Hi All,

I don't often have to work with currencies with excel so any help would be appreciated,

I have a link to the web creating a table price list, and then I've converted that data from the table to be able to sum it using the formula shown,

I have then created another link to a currency converter,

How can I apply the conversion to the data in column K:L?

I'd like to be able to convert the currencies in K:L to any other currency I would assume that K:L would remain as they are and then another column M? would have the selected currency value?

Any help or advice would be great thanks all,

 

[AlanY]

have a look if this work for you

Book1
	A	B	C	D	E	F
1	USD	GBP	JPY		Exchange Rates
2	4.62	3.86	526.33		USD	1
3	40.77	34.11	4649.25		GBP	0.8366
4	1.54	1.29	175.44		EUR	0.9477
5	31.54	26.39	3596.59		JPY	136.3115
6	66.92	55.99	7631.79		CHF	0.942
7	65.38	54.70	7456.34
8	34.62	28.96	3947.48
9	62.31	52.13	7105.46
10	67.69	56.63	7719.51
11	58.46	48.91	6666.85
Sheet1

Cell Formulas
Range	Formula
B2:C11	B2	=A2*VLOOKUP(B$1,$E$2:$F$6,2,0)

 

[pure vito]

That's Fantastic! thank you very much for your assistance Alan that's done the trick