VLOOKUP - 2 Questions

[Guest]

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

 

[Peo Sjoblom]

1. No

2. If you format the cell with the vlookup formula under
format>cells>alignment 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