If the V lookup is a bit puzzling try this in C1
=IF(A1=”GBP”,$H$5,IF(A1=”USD”,$H$6,IF(A1=”EUR”,$H$7,IF(A1=”AAA”,$H$8,IF(A1=”BBB”,$H$9,0)))))
Where H5 to H9 has your exchange rates in.
Or the V lookup is =VLOOKUP($A1,$G$5:$H$9,2,FALSE)
Where your symbols are in col G startig at row 5 and rates in H. Don’t forget the $ to stop the table moving when you drag the formula.