Vlookup List errors

I am running excel office XP and have a basic program to lookup my customers addresses. This is the code that I am using =IF(COUNTIF(AllCompanies,$A23)<>0,VLOOKUP('QUOTE TEMP'!$A23,AllData,2,FALSE),"") I am using a second hidden sheet as the "list" . A23 will give the customer # to lookup. It works great but I have approx 1500 customers and the program refuses to look past line #292 on the list. I realize that excel looks into ascending order and a lower value than your lookup value would result in a error. I have tried to sort and have even gone over each customer # one by one to look for typos but all customers above line 293 work fine. I even cut and pasted a few customers lower down the list to rows above 293 and they work fine. Im pulling my hair out trying to figure it out. Any help is greatly appreciated. Merry Christmas to all!!!!

Re: Vlookup List errors

basically I have 1500 customerst and thier address that looks like this

A1 B1
1 Cust # Name +Address
2 100 ABC Co. 300 oak street boston
3 101 ACME 200 state street newark
4 102 Smith Company 100 elm street
5 103 Joes Plumbing 50 pine street

The problem is I have over 1500 of them but the above macro will only read up to customer #293. I have tried everything. I have cut and pasted customers from way down the list and tested them above A293 and they work. All data below A293 is not being "Seen" I geuss. ????? :thanx: