Forum Discussion

CbcoppDDM's avatar
CbcoppDDM
Copper Contributor
Feb 04, 2022

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

  • CbcoppDDM 

    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.

    • CbcoppDDM's avatar
      CbcoppDDM
      Copper 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.

       

      • CbcoppDDM's avatar
        CbcoppDDM
        Copper Contributor
        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.

Resources