255 Character Limit

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 "send" 255 characters.


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

--

Dave Peterson

Thanks, that works perfectly

"Dave Peterson" wrote:

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