Forum Discussion
CbcoppDDM
Feb 04, 2022Copper Contributor
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
Sort By