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.

@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 :)

Highlighted
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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
33 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies