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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies