vlookup character limitations



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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question