how can i find a currency text in a column and multiply it by my own conversion rate using

You get better help if you post an Excel-example of your workbook, without confidential information.

thanks!
post #1 updated with excel link!

Maybe, like this.

Do you have questions, just ask.

thanks man!
maybe a few questions
1) so for column C which is the SGD, i have to enter function for each box that i going to add on?
2) for the currency text, its not possible to put it together with the price? as in "EUR 111.0" then use a method to detect the text on the left and amt on the right?

thanks!

oh thanks man!
i think for both the implementation, it boils down to whether i need to use 2 or 3 columns for these
thanks again to both of you!!!

Please refer in your answer to whom your replying.

1) you need tot add every value (euro / pounds / yen) at the table with values.

Otherwise it won't be found.

2) Problaby it can be done, but why do you want it that (complex) way.

You download the data from another source, and get it this way?