set up automatic currency detection in another column

Hi All,

I need help with Excel again, basically what I want to do is as follows. I have a list of names that need to be automatically assigned by excel to a currency.

i.e When ASDA is typed in, in the next collum labelled Currency it should automatically display USD.

Another Example Vodafone......GBP

Santander......EUR

etc.