# Vlookup formula stopped working

Occasional Visitor

# Vlookup formula stopped working

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.

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

2 Replies

# Re: Vlookup formula stopped working

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

# Re: Vlookup formula stopped working

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