Home

MS Excel - VLOOKUP result is not calculated automatically

%3CLINGO-SUB%20id%3D%22lingo-sub-463531%22%20slang%3D%22en-US%22%3EMS%20Excel%20-%20VLOOKUP%20result%20is%20not%20calculated%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-463531%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20application%20that%20generates%20a%20file%20that%20include%20VLOOKUP%20formulas%2C%20but%20the%20result%20is%20not%20calculated%20automatically.%20I%20need%20to%20manually%20press%20F2%20%2B%20Enter%20to%20have%20the%20result%20calculated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFacts%3A%3CBR%20%2F%3E-%20I%20already%20set%3A%20Formulas%20%26gt%3B%20Calculation%20Options%20%26gt%3B%20Automatic%3CBR%20%2F%3E-%20B6%3AB17%20and%20B19%3AB26%20have%20the%20%22General%22%20format%3CBR%20%2F%3E-%20B28%3A30%20and%20B32%3A34%20have%20the%20%22Numeric%22%20format%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EThe%20final%20idea%20is%20to%20print%20the%20text%20only%2C%20not%20the%20number%20zero%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20a%20copy%20from%20the%20file%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdrive.google.com%2Fdrive%2Ffolders%2F1ai_bHPXqfyZSQeSfUN8XcEIJz4fX7gqh%3Fusp%3Dsharing%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdrive.google.com%2Fdrive%2Ffolders%2F1ai_bHPXqfyZSQeSfUN8XcEIJz4fX7gqh%3Fusp%3Dsharing%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-463531%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Evlookup%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-463584%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20Excel%20-%20VLOOKUP%20result%20is%20not%20calculated%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-463584%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F322284%22%20target%3D%22_blank%22%3E%40John_P_%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%20John%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20see%20no%20problems%20with%20your%20file%2C%20it%20is%20calculated%20automatically%20if%20add%20any%20data%20in%20Settings.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20hide%20zeroes%20you%20may%20apply%20custom%20format%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3EGeneral%3BGeneral%3B%22%22%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-463611%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20Excel%20-%20VLOOKUP%20result%20is%20not%20calculated%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-463611%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BReally%3F%20what%20I%20see%20in%20computer%20is%20this%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdrive.google.com%2Ffile%2Fd%2F14_aiRSQiCBsGNKNyqcsFQlPDXtUqmRWu%2Fview%3Fusp%3Dsharing%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdrive.google.com%2Ffile%2Fd%2F14_aiRSQiCBsGNKNyqcsFQlPDXtUqmRWu%2Fview%3Fusp%3Dsharing%3C%2FA%3E%3C%2FP%3E%3CP%3EAnd%20the%20expected%20result%20would%20be%20actually%20B6%3D%221%20day%2C%202%20hours%22%20and%20so%20on%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-469012%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20Excel%20-%20VLOOKUP%20result%20is%20not%20calculated%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-469012%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F322284%22%20target%3D%22_blank%22%3E%40John_P_%3C%2FA%3E%20%2C%20that's%20my%20screen%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20353px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F109420i15BB1F6A87FDC3F2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20352px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F109422i406DB0FA4F022F8A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
John_P_
New 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

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies