What should I do if the vlookup function cannot match and only displays the formula?

The vlookup function cannot be matched and only the formula is displayed. Solution: 1. Enter the excel software interface; 2. Select the input vlookup function cell and double-click the cell; 3. Move the cursor to the front of the formula after the single quotation mark; 4. Click the Delete key on the keyboard to delete the single quotation mark, and then click the Enter key.

The operating environment of this tutorial: windows7 system, Microsoft Office Excel2016, Dell G3 computer.

What should I do if the vlookup function cannot match and only displays the formula?

Solution:

1. Double-click the cell with the function

to enter the excel software interface. In this interface, select the cell where you entered the vlookup function. Double-click this cell.

2. Place the cursor behind the single quotation mark

Until you see the mouse cursor start to flash, move the cursor behind the single quotation mark at the front of the formula .

3. Delete the single quote

Click the delete key on the keyboard to delete the single quote, and then click the Enter key to create your vlookup function The result will match.

Recommended study: "Excel Tutorial"

The above is the detailed content of What should I do if the vlookup function cannot match and only displays the formula?. For more information, please follow other related articles on the PHP Chinese website!