software

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

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 quot;sendquot; 255 characters.Colin wrote:
gt;
gt; I am doing a vlookup command and am it is only returning the first 255
gt; characters. How can I make it return them all?

--

Dave Peterson

Thanks, that works perfectly

quot;Dave Petersonquot; wrote:

gt; If you're using =vlookup() to return a value from a closed workbook, then open
gt; that other workbook (and force a recalculation).
gt;
gt; Closed workbooks will only quot;sendquot; 255 characters.
gt;
gt;
gt; Colin wrote:
gt; gt;
gt; gt; I am doing a vlookup command and am it is only returning the first 255
gt; gt; characters. How can I make it return them all?
gt;
gt; --
gt;
gt; Dave Peterson
gt;