Vlookups

Hi Esther

Thank you for your question. Vlookup brings back the value, but as you have found doesn't bring the number format with it. One option may be to record the currency symbol in a second column, alongside the currency rate then use a second VLOOKUP to return the symbol alongside the value.

Whilst this does not bring the number format along with the result could this help?

Let me know how you get on or if you have any other questions.

Kind regards,
Andrew