VLOOKUP - 2 Questions
 

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

VLOOKUP - 2 Questions
 

1. No

2. If you format the cell with the vlookup formula under
formatcellsalignment and check wrap text it will be multiple lines
whenever there is a carriage return, if you want to remove it or replace it
with a space

=SUBSTITUTE(VLOOKUP(A1,D3:E4,2,0),CHAR(10)," ")

will replace the carriage return with a space


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Kathy - Lovullo" wrote in message
...
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