Conversion of currencies

Help please!! I have a sheet that has a column with currency code and conversion rate. On another sheet I want it so that local currency value can be used, the appropriate currency code selected and then next column should auto convert to GBP for reporting purposes.

Can you help me to create this please?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!