You would need a macro to "look back" and copy the format from the source to
the destination (vlookup() result).
--
Gary''s Student - gsnu201001


"Ken Ent" wrote:

I have a named range with values containing special formatting (i.e.,
underlined initial letters, bolding, etc) that I would like to have returned
to another range based on a lookup(key) value. The lookup is successful
(using VLOOKUP) however, the special formatting is not returned. Both field
are text fields. Is there some way to perform a lookup and have the
formatting returned as well as the value?