vlookup doesn't retrieve subscript formatting Why?

[redmaple98]

I have set up a table which includes a column of scientific imperical
formulas (H20). I need to pull from this table to another (currently being
done with vlookup). Why doesn't the imperical formula pull in with
subscripting as it is formatted in the table? Does subcript carry through if
I use something other than vlookup?

[Peo Sjoblom]

Formulas cannot not carry over any formats like font type, colour,
bold/italic, subscript/superscript


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"redmaple98" <[email protected]> wrote in message
news:[email protected]...
>I have set up a table which includes a column of scientific imperical
> formulas (H20). I need to pull from this table to another (currently being
> done with vlookup). Why doesn't the imperical formula pull in with
> subscripting as it is formatted in the table? Does subcript carry through
> if
> I use something other than vlookup?
>