Vlookup formula stopped working

%3CLINGO-SUB%20id%3D%22lingo-sub-3113797%22%20slang%3D%22en-US%22%3EVlookup%20formula%20stopped%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3113797%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20fairly%20large%20workbook%20containing%20vlookup%20formulas.%26nbsp%3B%20Within%20the%20same%20workbook%2C%20the%20same%20formula%20works%20in%20one%20sheet%20but%20not%20in%20another.%26nbsp%3B%20Please%20advise.%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20the%20formula%3A%20%3DIFERROR(VLOOKUP(%5B%40Molecule%5D%2Cvlookup_all_brands8%2C2%2CFALSE)%2C%22%22)%3C%2FP%3E%3CP%3EAttached%20I%20have%20provided%20a%20screenshot%20of%20what%20it%20returns.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222022-02-03%20-%20Screen%20Shot%202022-02-03%20at%202.25.51%20PM.jpg%22%20style%3D%22width%3A%20108px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F345185i042A9F5152ECC815%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222022-02-03%20-%20Screen%20Shot%202022-02-03%20at%202.25.51%20PM.jpg%22%20alt%3D%222022-02-03%20-%20Screen%20Shot%202022-02-03%20at%202.25.51%20PM.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAs%20you%20can%20see%20it%20returns%20the%20formula%20instead%20of%20the%20result.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3113797%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3113929%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20formula%20stopped%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3113929%22%20slang%3D%22en-US%22%3ECheck%20to%20see%20if%20there's%20a%20single%20quote%20--%20'%20--%20at%20the%20start%20...that%20would%20cause%20the%20formula%20to%20be%20rendered%20as%20a%20text%20field.%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a fairly large workbook containing vlookup formulas.  Within the same workbook, the same formula works in one sheet but not in another.  Please advise. 

Here is the formula: =IFERROR(VLOOKUP([@Molecule],vlookup_all_brands8,2,FALSE),"")

Attached I have provided a screenshot of what it returns.2022-02-03 - Screen Shot 2022-02-03 at 2.25.51 PM.jpg

As you can see it returns the formula instead of the result.

2 Replies
Check to see if there's a single quote -- ' -- at the start ...that would cause the formula to be rendered as a text field.

@CMRiquinha 

Also check Formulas -> Show Formulas setting and if the cell is not formatted as text