Vlookup with retain cell format

[Jack T]

Dear All

I have a question, may i know how to use vlookup with maintain the cell format like Bold, Italic.

eg;
[TABLE="width: 500"]
<tbody>[TR]
[TD]Data[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]efg 123[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]efg 456[/TD]
[/TR]
</tbody>[/TABLE]

when using vlookup formula, all format will gone.

Can you provide solution​

 

[Special-K99]

VLOOKUP retrieves a cell value, it cannot retrieve the format of cell.
Cell format retrieval is only possible via VBA (I think), e.g.

A1 = ABC
B1 = ABC in bold

Both CELL("format",cell reference) just produce G for general, bold format is not detected in B1.
Your only hope is VBA.