Set up Automatic currency detection from a list of companies.

[emdad16]

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.

[TMS]

Patience ...

[emdad16]

Oh Sorry, I thought you weren't replying because you wanted me to start a new thread

[teylyn]

Closing thread because the discussion has been continued in http://www.excelforum.com/excel-gene...er-column.html