VLOOKUP Result not the same as the cell it is retrieving...

[ZaH1d]

Hi,

I have a mixture of cells with text on single or multiple (ALT + Enter) lines within a single cell.

I am using a VLOOKUP to retrieve the data from this column and want the result to contain the text as it's displayed.

e.g.

Cell A3 -
Consideration 1.
Consideration 2.
Considertaion 3.

I would want it to be displayed like above instead this is what is happening.

Consideration 1.Consideration 2.Consideration 3.

Any ideas? Let me know if this isn't clear and I will re-write it.

 

[wideboydixon]

Try formatting the cell that's displaying the result and select the "Wrap Text" option.

WBD

 

[ZaH1d]

Genius. So simple! Thank you.