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!