How can I retain the formatting of the data in a lookup table?

's Computer Specifications

When using the LOOKUP function, is it possible to retain the formatting of
the data in the lookup table so that the value returned appears in that same
formatting? What I mean is that the sorted table has some items formatted
differently (indented slightly and a smaller font), so I want these
characteristics retained whenever the LOOKUP function returns these values.
Thanks!

's Computer Specifications

The short answer is no. Formulas return values only. They can not return
formats.
--
HTH...

Jim Thomlinson

"spfowlerOH" wrote:

> When using the LOOKUP function, is it possible to retain the formatting of
> the data in the lookup table so that the value returned appears in that same
> formatting? What I mean is that the sorted table has some items formatted
> differently (indented slightly and a smaller font), so I want these
> characteristics retained whenever the LOOKUP function returns these values.
> Thanks!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
When refreshed, some Pivot Table columns retain formatting, some d	Josel	Microsoft Excel Worksheet Functions	0	22nd Apr 2010 05:50 PM
Retain pivot table formatting after refreshing data	Jazz	Microsoft Excel Worksheet Functions	0	6th Mar 2010 05:54 PM
Retain formatting of Excel sheet when copying data into it	carmela_wong@hotmail.com	Microsoft Excel Misc	5	27th Feb 2008 08:18 PM
How do I retain formatting from an Excel Data File to a Word Merg.	=?Utf-8?B?UG9va2Fz?=	Microsoft Word Document Management	5	14th Mar 2005 10:32 PM
Retain data in table based on changed data in another table	James	Microsoft Access Forms	3	14th Jan 2004 04:23 PM