This is a tricky one...
I have a sheet with zip code numbers - these have been converted to text and Vlook up was used as next step. Formulae works great for 2 months of data, no issues.
I have started 3rd month sheet of data, and the vlook up doesnt work anymore- N/A error with the exclamation saying number stored as text. I have formatted all cells as Text, I have no idea what is causing this, out of 4000 zip codes I have 1000 that are with ! and N/A.
But here is the fun part - As soon as I double click on that zipcode cell, the vlook up works?
1, formatted all cells as text
2, Set calculation to Automatic
What else is there am missing?