In general
Vlookup (other functions) just returns the value, not the font type or
formatting.

--
Regards,
Tom Ogilvy

"shashak" wrote in message
...

Hello!
How do I preserve font type and color formatting when using VLOOKUP?
For e.g. I am looking up data that has variety of fonts and colors.
Conditional formatting is limited to only 3 conditions. Is there a way
to programmatically preserve formatting when using VLOOKUP? Please
enlighten.


--
shashak
------------------------------------------------------------------------
shashak's Profile:
http://www.excelforum.com/member.php...o&userid=16265
View this thread: http://www.excelforum.com/showthread...hreadid=277005