New Contributor

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.



1 Reply

Figured it out.

Related Conversations
Custom value if a value is found using vlookup
Sam55 in Excel on
5 Replies
vlookup using concatenate function and helper column
Angela McGhin in Excel on
4 Replies
Vlookup doesn't work for inexplicable reason
Domonkos in Excel on
2 Replies
BowlingAlleyBob in Excel on
3 Replies
Need FORMULA help please!!
marislav in Excel on
4 Replies
Need some help with my Vlookup or a new idee
Jim Brastad in Excel on
5 Replies