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?

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?

thanks, I was afraid of that. If I knew how to write a macro to find a
specific cell and copy it's formatting, I would. Will look for alternatives,
but thanks for responding.

"Gary''s Student" wrote:

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?