ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   vlookup doesn't retrieve subscript formatting Why? (https://www.excelbanter.com/excel-discussion-misc-queries/85942-vlookup-doesnt-retrieve-subscript-formatting-why.html)

redmaple98

vlookup doesn't retrieve subscript formatting Why?
 
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

vlookup doesn't retrieve subscript formatting Why?
 
Formulas cannot not carry over any formats like font type, colour,
bold/italic, subscript/superscript


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"redmaple98" wrote in message
...
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?





All times are GMT +1. The time now is 02:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com