Forum Discussion

John_P_'s avatar
John_P_
Copper Contributor
Apr 16, 2019

MS Excel - VLOOKUP result is not calculated automatically

I have an application that generates a file that include VLOOKUP formulas, but the result is not calculated automatically. I need to manually press F2 + Enter to have the result calculated.

 

Facts:
- I already set: Formulas > Calculation Options > Automatic
- B6:B17 and B19:B26 have the "General" format
- B28:30 and B32:34 have the "Numeric" format

 

The final idea is to print the text only, not the number zero

 

Here is a copy from the file:
https://drive.google.com/drive/folders/1ai_bHPXqfyZSQeSfUN8XcEIJz4fX7gqh?usp=sharing

excel
Formulas & Functions
vlookup

3 Replies

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 16, 2019

    John_P_ 

    Hi John,

     

    I see no problems with your file, it is calculated automatically if add any data in Settings.

     

    To hide zeroes you may apply custom format 

    General;General;""
    • John_P_'s avatar
      John_P_
      Copper Contributor
      Apr 16, 2019

      SergeiBaklan Really? what I see in computer is this: https://drive.google.com/file/d/14_aiRSQiCBsGNKNyqcsFQlPDXtUqmRWu/view?usp=sharing

      And the expected result would be actually B6="1 day, 2 hours" and so on

Resources