V lookups

Hi Esther, thanks for your query. Functions such as VLOOKUP only return a value and not a format, so unfortunately you can't use VLOOKUP to do this. Try formatting the destination cell as a currency first then using the VLOOKUP function. The incoming data should be reformatted accordingly.

Hope this helps,

Anthony