Forum Discussion
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
Also check Formulas -> Show Formulas setting and if the cell is not formatted as text
- Check to see if there's a single quote -- ' -- at the start ...that would cause the formula to be rendered as a text field.
