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, but they do still show in the Pivot table we pull from. I am thinking that the fact that the value is now in the millions is causing problem, if this is issue need help fixing formula.
Thanks,
