VLOOKUP

I have a VLOOKUP formula that searched (pulls in) our top 40 customers.  Our top customer exceeded $1,000,000 in December.  I go to that Excel spread sheet and they do not show in the top 40 report, ...