Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
Retain formatting of Excel sheet when copying data into it | Excel Discussion (Misc queries) | |||
copy/paste want to retain cell coloration but lose the conditional formatting source data | Excel Discussion (Misc queries) | |||
Keep formatting with lookup table | Excel Discussion (Misc queries) | |||
Retain PivotTable formatting after "Refresh Data" | Excel Discussion (Misc queries) |