How do I get keep the format (superscript) from a table?

P

P3SAB$

I have a report that is using a vlookup to come up with a value. The
vlookup table has cells with superscripts. How do I keep the superscript
format when the lookup returns a value. Not all data in the table has a
superscript.
 
D

Dave Peterson

Formulas return values--not formats.

Maybe a macro that would copy|paste would work???
 
Top