That did the trick! I forgot to mention about trying Trim, then Clean, then
Cell Format to number and none of them working. I wish that I could be
updated with new info as easily as the programs but then I wouldn't have the
chance to say thank you very much.
Lee
"Max" wrote in message
...
... 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