SOLVED

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
Highlighted
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
Highlighted
Best Response confirmed by matyrze (New Contributor)
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 :)

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.