Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post - Excel VBA Question - Changing Format Cell To Particular Currency

Old Yeller · 11-14-2014, 10:38 AM

I haven't given this much thought, but could you not just have a hidden sheet with a lookup table with the currency in column A and the corresponding currency symbol in column B and then do a vlookup based on that?

11-14-2014, 10:38 AM	#2
Old Yeller First Line Centre Join Date: Mar 2004 Exp:	I haven't given this much thought, but could you not just have a hidden sheet with a lookup table with the currency in column A and the corresponding currency symbol in column B and then do a vlookup based on that?