Vlookup question.

[AJL]

Hello again.

I am using Vlookup to return from a table than contains large sections of
text, however, what is returned in the cells is only a portion of the text in
the cell being search, not the whole paragraph. Is there anyway to get
Vlookup to return all the text that is in that cell? Thanks.

-Alan Lueke

 

[Don Guillett]

destination cell larger or format to wrap text

 

[Gord Dibben]

Alan

How large is "large"?

Do you see all the text in the formula bar, but not in the cell?

You can enter 32767 characters in a cell, but Excel will display or print only
1024 of these characters in the cell.

If this is the case, paste special>values in your lookup cell then stick in an
ALT + ENTER every 100 characters.

Someone else may have another(better) workaround so hang in.


Gord Dibben MS Excel MVP