hi
going out on a limb here but as i understand it, formulas return values to
the cell in which they reside. they cannot return formats. nor perform
actions like reform a cell. to reform a cell, you may need a macro.

Regards
FSt1

"thenight-train" wrote:

I am using both VLOOKUP and HLOOKUP to move data throughout a spread sheet.
I need to format of the data to move as well as the value. I am pulling
several different types of data in to the same cell based on the look up
value. Any ideas?