Vlookup formula stopped working

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