ExcelBanter - VLookup accesses half the text in a field?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VLookup accesses half the text in a field? (https://www.excelbanter.com/excel-worksheet-functions/5989-vlookup-accesses-half-text-field.html)

CIDERIE

VLookup accesses half the text in a field?

I have specifications in one file and results in another.
When the results file looks up data in the specifications file only half the
text in a long filed is displayed when the source is inactive. If I load the
source file at the same time then all the data is displayed. is this a
"feature" of excel 2003 it never happened in excel 97?

Frank Kabel

hi
the max is IMHO 255 characters if the other file is closed

--
Regards
Frank Kabel
Frankfurt, Germany

"CIDERIE" schrieb im Newsbeitrag
...
I have specifications in one file and results in another.
When the results file looks up data in the specifications file only
half the
text in a long filed is displayed when the source is inactive. If I
load the
source file at the same time then all the data is displayed. is this
a
"feature" of excel 2003 it never happened in excel 97?

All times are GMT +1. The time now is 04:30 PM.