Automatically Change to Correct Currency

[kiyo052]

I feel like the answer is NO but I thought I should ask:

If A1= list of currencies (USD, AUD, CAD, EUR, GBP)
Can A2= a number with the correct currency symbol from A1

Example:
A1= USD
A2= $300

A1= AUD
A2= AUD 600

A1=CAD
A2= CAD 100

A1= EUR
A2= €500

A1= GBP
A2= £240

 

[oldbrewer]

are you familiar with vlookup ? if G1 = USD and H1 = $ etc for all currencies just find the matching one and return the correct symbol

so if A1 = USD where does the 300 come from
pretend it is in B1
so A2 = B1&vlookup(A1, mytable,2)
where mytable is the list of currency names and symbols