Trying to do some vlookup equations... they are working fine, but they only
bring over the value, not the formating. In the particular problem I'm
working on, the text value may or may not end with a superscripted number
(test^1). When the vlookup happens, the text appears the superscripted
number appears as regular text (test1). Anyway to build formating
capabilities within an equation?

Formulas return values--not formatting.

Maybe you could use a macro to copy|paste???

jomurf wrote:

Trying to do some vlookup equations... they are working fine, but they only
bring over the value, not the formating. In the particular problem I'm
working on, the text value may or may not end with a superscripted number
(test^1). When the vlookup happens, the text appears the superscripted
number appears as regular text (test1). Anyway to build formating
capabilities within an equation?

--

Dave Peterson