No, a VLookup formula can only return a value, not the formatting from
the original cell.

Perhaps you could use conditional formatting to format the cells, based
on the value returned. There are instructions in Excel's Help, and he

http://www.contextures.com/xlCondFormat01.html

peter_rivera wrote:
On Sheet1, I have data with cells that have different formatting (e.g.
different text colors/bold/etc.). On Sheet 2, I have a vlookup formula
that shows the data presented on Sheet 1, but without the formatting.

Is it possible while using a vlookup formula to display both the data
and the data's original formatting? If not, how else can I accomplish
this? Thanks!!!




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html