Forum Discussion

garywayne911's avatar
garywayne911
Copper Contributor
Jun 05, 2019

vlookup not working in one of my worksheets

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

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Try pressing Ctrl+GraveAccent, which found at the left of 1 on the keyboard.