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!