vlookup character limitations

[808bobby]

is vlookup limited in retrieving cell contents greater than 255 characters? I
have a vlookup function that is properly retrieving the cell, but the text
string is truncated at 255. Is there some way to grab the entire cell content
or some work around to this?

 

[Dave Peterson]

No, =vlookup() isn't limited like that.

But if your sending workbook is closed, excel and windows are limited that
way--even with a simple formula that points a cell.

If you open the workbook (and recalculate), you'll see the entire string.