ExcelBanter - Capturing Formatting with VLookup

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

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

- - Capturing Formatting with VLookup (https://www.excelbanter.com/excel-discussion-misc-queries/257327-capturing-formatting-vlookup.html)

kalandine

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?

L. Howard Kittle

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?

All times are GMT +1. The time now is 11:09 AM.