| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Capturing Formatting with VLookup
I am using VLOOKUP to search through a db that has formatting on individual
cells (text color, subscript, superscript, etc.). The result from a successful VLOOKUP is in place text. Is there any way to have the lookup cell automatically match the formatting of the reference cell? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Capturing Formatting with VLookup
A formula can only return a value to a cell, so I say the answer is no.
HTH Regards, Howard "kalandine" wrote in message ... I am using VLOOKUP to search through a db that has formatting on individual cells (text color, subscript, superscript, etc.). The result from a successful VLOOKUP is in place text. Is there any way to have the lookup cell automatically match the formatting of the reference cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Capturing Top 5 Performers | Excel Worksheet Functions | |||
| Formula capturing formatting information | Excel Discussion (Misc queries) | |||
| Autofilter not capturing all cells | Excel Worksheet Functions | |||
| capturing all of the data | Excel Worksheet Functions | |||
| Capturing Date | New Users to Excel | |||
Linear Mode
