Hi all!

In my sheet, lets say from cell C to F, there would be values in different currencies i.e. EURO, US and GBP but i want the end result to be always in US. For example, i want to know if its possible that if someone puts a value in EURO, it should lookup in a cell which would have EURUSD exchange rate and convert the inserted EUR value into US. The same should happen for GBP.

FYI, if a value is in EUR or GBP, the cell is formatted manualy to display EUR or GBP sign.

I came across the below thread while searching the fourms and it looks similar to mine but i don't understand it all as i am a real noob in excel.

http://www.excelforum.com/excel-gene...cy-symbol.html


I hope my explanation is clear enough.