Potential Reasons and Solutions
First, check that there is an equals sign (=) ahead of your formula.
Next, check that there isn’t an apostrophe (‘) before your formula
Then click on the Formulas Tab to see that the “Show Formulas” button isn’t on
Lastly, check that the cell isn’t formatted as text. If it is, then change it to General.
Want to get good at using the VLOOKUP function?
Download our practical VLOOKUP tutorial workbook with step-by-step instructions and examples to help you become a VLOOKUP pro.