Set up Automatic currency detection from a list of companies.

Hi All,

I have a list of companies and currencies. The company names are in a list and the idea is when some1 clicks a company name from the drop down list the currency should appear on the right hand side of the list.

i.e. If I select Santander from the drop down list, on the RHS EUR sould appear

Thanks

P.S. I have attached a dummy workbook.