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 this formula for years, and never had an issue. Why won't it do the lookup? The range is correct, data is sorted in ascending order. I am looking to match content. I did it successfully looking from the tab RE GP at the tab where I want to do the look up. There aren't any extra spaces. It looks like my commas are in place. Thanks so much!
4 Replies
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.
- CbcoppDDMCopper Contributor
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.
- CbcoppDDMCopper ContributorI 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.