Feb 03 2022 02:29 PM
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.
Feb 03 2022 03:00 PM
Feb 04 2022 05:00 AM
Also check Formulas -> Show Formulas setting and if the cell is not formatted as text