software

I work with chemical formulas which include subscript formatting i.e.
H2O (the 2 should be subscript. Even here I can't get the subscript to
follow with copy/paste). I work in Excel 2003

I want to pull from one table to another , but I need it to pull the
subscripted character as is. I've tried to find a similar thread and
have worked with INDEX - MATCH combos but no success. VLOOKUP has
certainly not worked. It pulls the text but without the subscripting.

Is there some combination of functions which will pull text as
formatted from one table to another?

I thought I might have been onto something with this but I get #VALUE
as result.

=CELL(quot;textquot;,OFFSET(number,MATCH(A29,jde,0),3))
number = lookup value jde = lookup array

If I replace quot;textquot; with quot;formatquot; I get G (general) although the cell
in original table is text.

If functions don't work can VBA help?Don't use subscripts, use a font that has the digits as sub and subscripts
in its character set.
See
www.stfx.ca/people/bliengme/E...and_Charts.htm
for such a font.
best wishes and don't drink too much dihydrogen monoxide with out adding
ethanol.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;red maple 98quot; gt; wrote in message ups.com...
gt;I work with chemical formulas which include subscript formatting i.e.
gt; H2O (the 2 should be subscript. Even here I can't get the subscript to
gt; follow with copy/paste). I work in Excel 2003
gt;
gt; I want to pull from one table to another , but I need it to pull the
gt; subscripted character as is. I've tried to find a similar thread and
gt; have worked with INDEX - MATCH combos but no success. VLOOKUP has
gt; certainly not worked. It pulls the text but without the subscripting.
gt;
gt; Is there some combination of functions which will pull text as
gt; formatted from one table to another?
gt;
gt; I thought I might have been onto something with this but I get #VALUE
gt; as result.
gt;
gt; =CELL(quot;textquot;,OFFSET(number,MATCH(A29,jde,0),3))
gt; number = lookup value jde = lookup array
gt;
gt; If I replace quot;textquot; with quot;formatquot; I get G (general) although the cell
gt; in original table is text.
gt;
gt; If functions don't work can VBA help?
gt;
I couldn't find a link to the font in the page, just the example. Doing a
google search I could download the font from:
www.ars-chemia.net/Classes/ChemSanSerif.TTF

It is really nice! Thanks, Bernand.
Miguel.

quot;Bernard Liengmequot; wrote:

gt; Don't use subscripts, use a font that has the digits as sub and subscripts
gt; in its character set.
gt; See
gt; www.stfx.ca/people/bliengme/E...and_Charts.htm
gt; for such a font.
gt; best wishes and don't drink too much dihydrogen monoxide with out adding
gt; ethanol.
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;red maple 98quot; gt; wrote in message
gt; ups.com...
gt; gt;I work with chemical formulas which include subscript formatting i.e.
gt; gt; H2O (the 2 should be subscript. Even here I can't get the subscript to
gt; gt; follow with copy/paste). I work in Excel 2003
gt; gt;
gt; gt; I want to pull from one table to another , but I need it to pull the
gt; gt; subscripted character as is. I've tried to find a similar thread and
gt; gt; have worked with INDEX - MATCH combos but no success. VLOOKUP has
gt; gt; certainly not worked. It pulls the text but without the subscripting.
gt; gt;
gt; gt; Is there some combination of functions which will pull text as
gt; gt; formatted from one table to another?
gt; gt;
gt; gt; I thought I might have been onto something with this but I get #VALUE
gt; gt; as result.
gt; gt;
gt; gt; =CELL(quot;textquot;,OFFSET(number,MATCH(A29,jde,0),3))
gt; gt; number = lookup value jde = lookup array
gt; gt;
gt; gt; If I replace quot;textquot; with quot;formatquot; I get G (general) although the cell
gt; gt; in original table is text.
gt; gt;
gt; gt; If functions don't work can VBA help?
gt; gt;
gt;
gt;
gt;