Converting Currency Format

Hi there,

I have a spreadsheet with a number of currencies that I want the format of a cell to change to given whatever currency I have inputted in another column.

I actually found a code online that works really well if it was for 1 currency, but was wondering if someone could help change the code so that it would read for multiple currencies in different lines?