Cannot Vlookup of Large file

M

Microsoft Excel

Dear all Helper,

I have a excel file of about 20,000 records.
I have another worksheet for vlookup to this excel file.
But find that it exists in both worksheet but it prompt #N/A.

Do you have any hints or reasons?
Any other solutions?
 
M

Martijn

Rudolf,

Show us the formula of Vlookup, it might be a problem in the code.
Check also the properties of the lookup-value and the database-value.

If you are looking for a number e.g. 10 and in the database the cell
property is "text" (10 is now '10) Vlookup will not find it.

grtx's Martijn
 
D

Dave Peterson

Often times, it a difference in data.

Numbers treated as numbers in one file and as text in the other--or additional
spaces (leading/trailing/embedded) in one, but not the other. Or just simple
typing errors.

Or the table may not be large enough in your formula.
 
Top