View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default vlookup character limitations

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.

808bobby wrote:

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