vlookup displays formulas because the cells that should display data are set to non-text format or because the formula option is checked to display formulas. The solution: 1. Find the cell that displays the formula, Then right-click and select "Format Cells"; 2. Change the non-conventional classification on the "Number" interface to "General" and click "OK" to save.
The operating environment of this tutorial: Windows 10 system, WPS Office 2019 version, Dell G3 computer.
Why does vlookup display formulas?
In fact, there are only two reasons why the vlookup function only displays formulas. The first point is that we set the cells that should display data to non-text format, and the second point is that we set the The formula option has Show formula checked. Below I will give you a solution to the problem from these two points.
We find the cell that displays the formula, then right-click and select "Format Cells".
Then we change the non-conventional classification on the "Number" interface to "General" and click OK to save.
We switch to the form. At this time you will find that the data on the form has turned into numbers, so this means that we Already successful.
If it doesn’t work, you must be using an old version of the office software, but it’s not a big problem. Let’s choose the “ Formula" and then click "Show Formula" so that the vlookup function will not only display the formula. Isn't it very simple?
Excel Tutorial"
The above is the detailed content of Why does vlookup display formulas?. For more information, please follow other related articles on the PHP Chinese website!