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...
excel
Formulas & Functions
vlookup
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