vlookup character limitations

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?
 
D

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

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Vlookup 1
Searching the formula (not the value) for a text string 1
Character limit when retrieving indirect text from external sheet 3
Countif Limitations 4
vlookup formatting problem 1
using strings in vlookup function calls 5
Is there a 255 character limit in pivot table cells? 1

Top