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

S

spfowlerOH

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!
 
J

Jim Thomlinson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can the font and size of (all) citation numbers be altered? 1
Table lookup 1
formatting a cell the same as the source cell from a lookup table 2
Can I use a lookup on data containing duplicate entries? 2
I need to retain the formatting from a different part of a spreads 1
VLOOKUP not working due different formats in lookup data & table? 2
'# N/A" result in V-Lookup 0
When refreshed, some Pivot Table columns retain formatting, some d 0

Top