No, a formula can not be used to convey formatting information, only values.

If the cell shading is applied through conditional formatting, though, the
same conditional formatting could be applied to the cell with the VLOOKUP
formula in, to achieve the same effect.

Pete

"Sherry" wrote in message
...
I am pulling in data using a Vlookup and would like for it to keep the same
cell color shading as in the original spreadsheet that it is pulling from.
Is this possible?