I have 2 questions in regards to VLOOKUP.

1 - Is it possible to retrain the format of the cell which you are pulling
the value of? For example text color

2 - In some of the original cells, the Alt+Enter key was used to perform a
cariage return within a cell. When VLOOKUP returns these cells, the cariage
return shows as a block-type wingding. Is there a way to turn this back into
a carriage return either through the function or using code?

Thanks!
Kathy