vlookup character limitations

  • Thread starter Thread starter 808bobby
  • Start date Start date
8

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?
 
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.
 
Back
Top