Forum Discussion
Vlookup not calculating
here is my formula...for some weird reason it isn't calculating... =VLOOKUP(A2,'RE GP'!A$1:A$5600,1,FALSE) it just remains in the cell as is, with the = sign and the formula I've used thi...
1) Make sure that the cell with the formula is not formatted as Text.
2) Make sure that Show Formulas in the Formula Auditing group of the Formulas tab of the ribbon is not highlighted.
HansVogelaarThanks for getting back to me so quickly. The field is not formatted as text...it is formatted as General. And show formulas is NOT highlighted.
This is such a mystery because it works in a spreadsheet on another tab.
- I don't know what I did, but I created a new column and when I hit the tab key it worked...both are formatted as general. The excel goblins didn't want me to work any more on Friday so they were playing tricks. But now I'm back in business. Thanks again.
This is a great tip, thank you very much for sharing... It worked for me as well.
