Maybe the two items, the value you are looking up and the lookup table are
not actually of the same data type.........one may look like numbers but
actually be text so the lookup will not find it.........I've had this
problem many times before......

hth
Vaya con Dios,
Chuck, CABGx3




"Neophyte" wrote in message
...
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