255 Character Limit

C

Colin

I am doing a vlookup command and am it is only returning the first 255
characters. How can I make it return them all?
 
D

Dave Peterson

If you're using =vlookup() to return a value from a closed workbook, then open
that other workbook (and force a recalculation).

Closed workbooks will only "send" 255 characters.
 
C

Colin

Thanks, that works perfectly

Dave Peterson said:
If you're using =vlookup() to return a value from a closed workbook, then open
that other workbook (and force a recalculation).

Closed workbooks will only "send" 255 characters.
Click to expand...
 
Top