I have exported from an Order Entry program to comma delimited text file
customer purchases. The file has more entries than Excel can handle on one
worksheet. So, I imported the file data into Access (107,000+entries). I
then used Excel's "Query Database" feature to import customer level
purchases into 4 worksheets. The Order Entry program didn't export customer
names, only customer numbers. So, I exported the customer info to another
text file and imported it into the Excel Workbook, only 451 entries . The
problem is when I did a vlookup function to retrieve the customer name into
the worksheet with the customer number, it works when I go into a customer
number cell with "F2" and exit. Otherwise, I get the #N/A error because I
have it set to false. My formula is
=VLOOKUP(A2,Customers!$A$2:$C$415,3,FALSE) in the invoice worksheets. I am
using Office 2000.
What do I need to do to make things work? I know this hard to follow and
trying to explain it is not easy but any help is greatly appreciated. I know
more about Excel than Access and that isn't saying much!
Thank you very much.
Lee
Bookmarks