Bring in cell format

[prender]

If I write a formula in a cell such as "=VLOOKUP(F9,Vacation_initials,2)" to
bring in the contents of a cell on another worksheet, is there a way to also
bring along the formatting of that cell? In this case, I'm choosing from a
range of 256 cells each of which has a different format.

 

[Bernard Liengme]

I am afraid not
best wishes

 

[Don Guillett]

A formula may only return a value, not a format. macro required.