MS Excel - VLOOKUP result is not calculated automatically

Copper Contributor

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

3 Replies

@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;""

@Sergei Baklan 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