Question: Why is my VLOOKUP formula still showing as a formula and not the result?

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

The Show Formulas option should be deselected if you want to see the formula result

The Show Formulas option should be deselected if you want to see the formula result

 

 

 

 

 

 

 

 

Lastly, check that the cell isn’t formatted as text. If it is, then change it to General.

Excel general format

 

 

 

 

 

 

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.

3 thoughts on “Question: Why is my VLOOKUP formula still showing as a formula and not the result?

  1. Shirley Anderson

    It is not my first time to pay a quick visit this web site. I visit this web page daily and get useful information from here every day to build my excel skills for my consulting role.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *