Hi,

I've been trying to get my head around how to do this for a while now, I know I need to use a combination of match and vlookup etc. but I'm not sure how.

EUR		                0.25	0.29	0.49	0.75	0.79	0.89	0.99	1.19	1.39
AUD	Australia	        0.35	0.35	0.65	1.05	1.15	1.25	1.45	1.75	2.05
NZD	New Zealand	        0.45	0.55	0.85	1.35	1.45	1.65	1.85	2.25	2.65
I need to convert prices in a but vary the colum reference based on the value

e.g. A product costs 1.15 AUD, I would then like to be able to automatically convert it to 0.79 EUR i.e. lookup of the value with the column number dependant on the value in AUD. So if I were to have 2.25 NZD it would return 1.19 EUR.

Let me know if you need further explanation,
Thanks