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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I retain the formatting of the data in a lookup table? (https://www.excelbanter.com/excel-discussion-misc-queries/252685-how-can-i-retain-formatting-data-lookup-table.html)

spfowlerOH

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

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!

Jim Thomlinson

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

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!

All times are GMT +1. The time now is 01:59 PM.