| Home |
| Search |
| Today's Posts |
|
#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! |
| 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) | |||
Threaded Mode
