Returning Formatting on a Lookup

[Ken Ent]

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?

 

[Gary''s Student]

You would need a macro to "look back" and copy the format from the source to
the destination (vlookup() result).

 

[Ken Ent]

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.