SOLVED
Home

Problem with VLOOKUP

%3CLINGO-SUB%20id%3D%22lingo-sub-393533%22%20slang%3D%22en-US%22%3EProblem%20with%20VLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-393533%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20all%2C%20Would%20like%20to%20get%20help%20on%20vlookup%20command%2C%20as%20shown%20in%20photo%20attached.%20The%20command%20in%20right-hand-side%20excel%20docs%20has%20not%20return%20the%20value%20from%20H%20column%20(activity%20description)%20in%20left-hand-side%20excel%20document%2C%20rather%20it%20just%20seems%20to%20show%20the%20formula%20as%20text%20only.%20Can%20anyone%20advice%20how%20to%20fix%20the%20vlookup%20in%20the%26nbsp%3B%3CSPAN%3Eright-hand-side%20excel%3F%20Appreciate%20any%20help..thank%20you.%20Regards.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-393533%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-393660%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20VLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-393660%22%20slang%3D%22en-US%22%3EThe%20problem%20is%20obvious.%20Your%20cells%20are%20showing%20formulas%20instead%20of%20results.%20You%20just%20didn't%20know%20how%20to%20hide%20formulas%20and%20show%20results.%20But%20now%20you%20know!%20If%20you%20press%20the%20same%20keyboard%20shortcut%20again%2C%20The%20formulas%20will%20show%20instead%20of%20results.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-393648%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20VLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-393648%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3EThanks%20a%20million%20for%20your%20response%2C%20and%20it%20worked%20haha!%20I%20am%20not%20really%20expert%20with%20excel%20yet%2C%20but%20is%20the%20solution%20readily%20available%20in%20the%20help%20section%3F%20Or%20this%20shall%20come%20through%20experience%20and%20by%20asking%20around%20in%20forums%3F%20When%20I%20encountered%20this%2C%20I%20was%20not%20sure%20what%20to%20search%20in%20the%20help%20section!%20Thanks%20again%20%3A)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-393544%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20VLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-393544%22%20slang%3D%22en-US%22%3EYou%20must%20have%20executed%20the%20%22show%20formulas%22%20command.%20Try%20Ctrl%2B%60.%20The%20Grave%20Accent%20(%60)%20is%20located%20at%20the%20left%20of%201%20on%20the%20keyboard.%3C%2FLINGO-BODY%3E
matyrze
New Contributor

Dear all, Would like to get help on vlookup command, as shown in photo attached. The command in right-hand-side excel docs has not return the value from H column (activity description) in left-hand-side excel document, rather it just seems to show the formula as text only. Can anyone advice how to fix the vlookup in the right-hand-side excel? Appreciate any help..thank you. Regards.

3 Replies
Solution
You must have executed the "show formulas" command. Try Ctrl+`. The Grave Accent (`) is located at the left of 1 on the keyboard.
Highlighted

@TwifooThanks a million for your response, and it worked haha! I am not really expert with excel yet, but is the solution readily available in the help section? Or this shall come through experience and by asking around in forums? When I encountered this, I was not sure what to search in the help section! Thanks again :)

The problem is obvious. Your cells are showing formulas instead of results. You just didn't know how to hide formulas and show results. But now you know! If you press the same keyboard shortcut again, The formulas will show instead of results.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies