... 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)
What do I need to do to make things work?

As a first guess, try adding a zero to the lookup value, viz use instead:
=VLOOKUP(A2+0,Customers!$A$2:$C$415,3,FALSE)

Adding a zero is just one way of coercing the text numbers in col A to a
real numbers to enable correct matching with the lookup col A in Customers
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Neophyte" wrote:
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