Returning Formatting on a Lookup

  • Thread starter Thread starter Ken Ent
  • Start date Start date
K

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?
 
You would need a macro to "look back" and copy the format from the source to
the destination (vlookup() result).
 
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.
 
Back
Top