Home

vlookup not working in one of my worksheets

%3CLINGO-SUB%20id%3D%22lingo-sub-670918%22%20slang%3D%22en-US%22%3Evlookup%20not%20working%20in%20one%20of%20my%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-670918%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20have%20a%20large%20worksheet%20that%20%22vlookup%22%20shows%20the%20formula%20and%20not%20the%20result.%20vLookup%20works%20in%20other%20worksheet%20just%20not%20the%20one.%26nbsp%3B%20Vlookup%20works%20in%20the%20other%20worksheets.%20I%20have%20NO%20circular%20formulas%20or%20errors.%20It%20looks%20like%20the%20issue%20is%20with%20the%20worksheet%20and%20not%20the%20formula.Is%20there%20a%20command%20to%20CLEAN%20the%20worksheet%20or%20workbook%3F%26nbsp%3B%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-670918%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-670952%22%20slang%3D%22en-US%22%3ERe%3A%20vlookup%20not%20working%20in%20one%20of%20my%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-670952%22%20slang%3D%22en-US%22%3ETry%20pressing%20Ctrl%2BGraveAccent%2C%20which%20found%20at%20the%20left%20of%201%20on%20the%20keyboard.%3C%2FLINGO-BODY%3E
garywayne911
Occasional Visitor

Hello, I have a large worksheet that "vlookup" shows the formula and not the result. vLookup works in other worksheet just not the one.  Vlookup works in the other worksheets. I have NO circular formulas or errors. It looks like the issue is with the worksheet and not the formula.Is there a command to CLEAN the worksheet or workbook?  Thank you

1 Reply
Try pressing Ctrl+GraveAccent, which found at the left of 1 on the keyboard.
Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies