M
mmm206
I originally had a rather large file (5K rows X 40 colums) that I created a
new smaller (~5 columns) file from so I could perform some analysis on the
smaller file. I am now using vlookup on the smaller file to add back in a
column of data or 2 from the original file. The vlookup is working on about
4000 of the 5000 values and returning the correct info, except for about 1000
lines where I am getting "#Value" errors. The lookup_value that I am trying
to match is text. I've already sorted then tried CLEANing and TRIMming to no
avail. I have a feeling that this issue has something to do with formatting,
or possibly leading ", - or ( characters, or the length of the text string.
But it seems arbitrary since some lookups are returned correctly and others
are not.
new smaller (~5 columns) file from so I could perform some analysis on the
smaller file. I am now using vlookup on the smaller file to add back in a
column of data or 2 from the original file. The vlookup is working on about
4000 of the 5000 values and returning the correct info, except for about 1000
lines where I am getting "#Value" errors. The lookup_value that I am trying
to match is text. I've already sorted then tried CLEANing and TRIMming to no
avail. I have a feeling that this issue has something to do with formatting,
or possibly leading ", - or ( characters, or the length of the text string.
But it seems arbitrary since some lookups are returned correctly and others
are not.