Forum Discussion
Vlookup not working in large file
I am doing a vlookup comparing two large files (200,000+ rows). The data I'm doing to vlookup on are in the number format. The vlookup will return approximately 2/3 of the data, but the other 1/3 sho...
When I have this issue, it's usually some data on my lookup table is saved as numer and some as text.
The way I eliminate that as an issue, I select the column(s) in my lookup table, go to Data, select text to Columns, confirm "deliminted" is selected, and click finish. That should convert any text to numbers.
The way I eliminate that as an issue, I select the column(s) in my lookup table, go to Data, select text to Columns, confirm "deliminted" is selected, and click finish. That should convert any text to numbers.