Vlookup Cell Format

[Richard]

Can vlookup or any other function bring over the cell formatting?

 

[Mr. Haney]

Nope.

Formulas return values.

Can a macro copy and paste or otherwise "grab" a cell's formatting for
use in another cell or sheet?

 

[Dave Peterson]

Yep.

But knowing when to run the macro may be difficult to determine.

If you only cared about the cell that is used as the lookup value changed, then
you may be able to use the worksheet_change event (if the user typed in the new
value).

But if the table were reformatted, then this event would not fire.