Excel 2010 vlookup formula does not produce results

It may be that there are spaces or non-displayable characters in the raw data, or that the column in which you wrote the formula is in text format.

You can troubleshoot the cause of the problem and resolve it as follows:

Method 1: See if the column where the formula is written is in text format, if so, change it to regular, and then the cell, press enter again after the formula.

Method 2: Press Ctrl+ or Tools, Options, View, Unchecked, Formula, and click OK.

1. The lookup value is the value that needs to be found in the first column of the data table. The lookup value can be a numeric value, a reference, or a text string. If the first parameter of the vlookup function omits the search value, 0 is used to search the value.

2. Table array is the data table in which you need to find data. Use a reference to the region or region name.

3. Col index num is the data column number of the data searched in the table array. When the col index num is 1, the value of the first column of the table array is returned, when the col index num is 2, the value of the second column of the table array is returned, and so on. If the col index num is less than 1, the function vlookup returns an error value value!

If col index num is greater than the number of columns in the table array, the function vlookup returns an error value of ref!.

4. Range lookup is a logical value, which indicates whether the function vlookup is an exact match or an approximate match when looking for it. If false or 0, an exact match is returned, and if it is not found, an error value of n a is returned. If Range Lookup is true or 1, the function vlookup will look for an approximate match, that is, if an exact match value is not found, it returns the maximum value less than the lookup value.

If the range lookup is omitted, it defaults to an approximate match.

Check it: 1. Whether the formula input is correct: the formula leader should be a half-shaped equal sign;

2. The cell format cannot be a text type;

3. Excel is not set to display the formula (formula, formula audit, display formula).

The biggest possibility is that the format of the cell in which the formula is located is pre-set to "Text", and the solution is to format its cells as "General".

According to your description, it is likely to be a cell formatting problem for setting formulas, please try it as described below, hope it can help you.

1. Make your current formula clear;

2. Select the cell or region you want to formulate;

3. Right-click in the selected state - set the cell format - number - select "General" in the drop-down menu - OK.

4. Re-formulate the formula.

Outcome? nfjle most beautiful love in time. rememberumvw

The following settings are required:

1. Set the cell to display the calculation result: File Option Advanced The display option of this worksheet, do not check "Show formula in cell instead of its calculation result";

2. The cell format cannot be text, right-click the cell and set the cell format to normal;

If there is no problem with the above settings: select this column, and click "Done" directly in the Data Tools column.

Try the following steps:

1. Press Ctrl+ to toggle the "Show Formula" state;

2. Change the cell format from "Text" to "General", press Enter.

3. Check whether the formula is preceded by an equal sign =.

In our daily work, we will encounter the problem that the calculation result is not displayed in excel and only the formula is displayed, so how to solve it? In this article, I will share some tips.

Tools Raw materials.

Excel, computer.

Method steps.

The first possibility is that after clicking on the cell, you find that there is no "=" entered

Add "=" in front of the formula

After clicking Enter, the calculation result is automatically displayed.

Another case is when an equal sign and a formula are displayed after input, but the calculation result is not displayed.

Select the cell, right-click, and select Format Cell.

Usually the format is selected as text and changed to a numeric value.

After clicking OK, double-click on the cell, and the calculation result will appear.

How to solve the problem that excel does not show the calculation result and only shows the male fiber empty experience.

The reason for this problem: When using the vlookup formula, the absolute reference symbol is not used to refer to the cell range, resulting in the partial number cannot be taken out.

The following examples are given to solve the problem, and the detailed operation steps are as follows:

1. First of all, enter the cell data that needs to be extracted in the excel sheet, and fill in the data in column E according to the data in column A, as shown in the figure below.

2. Secondly, click "fx" to insert the function, and then click "vlookup" as below screenshot shown.

3. Then, according to the functional parameters in the following figure, input them into the parameter list, and convert them into formulas: =vlookup(a1,$d$1:$e$5,2,0), as shown in the following figure.

4. Finally, click OK to generate the calculation result. You can see that in column B, the values in column E have been filled in based on the data in column A, as shown in the following figure.

Excel vlookup function.

The specific steps to display only formulas and not results are as follows:

The materials we need to prepare are: computer, excel**.

1. First of all, we open the required excel** and click on the cell to enter the formula.

2. Then we click to open "Formula" in the main menu bar.

3. Then we click on the pop-up page and select "Show Formula" to only display the formula but not the result.

1. First of all, we open our computer, and then we open the excel document on our computer where the formula is entered and the calculation result is not displayed;

2. After that, we click on the formula; This is important;

3. Then we click on the drop-down arrow below the calculation options;

4. In the pop-up interface, we can see that it is manual at this time, and we click Automatic, so that the result will be calculated.

The specific steps of the Excel vlookup function only display the formula and do not display the result of the scramble are as follows:

The materials we need to prepare are: computer, excel**.

1. First of all, we open the excel** that we need to pin the companion, and click on the cell to enter the formula.

2. Then we click to open "Formula" in the main menu bar.

3. Then we click on the pop-up page and select "Show Formula" to only display the formula but not the result.

Answer: Because you set up only to show the formula rotten. Solution: Press the key combination Ctrl+ to display the result of the stool.

This is the array formula, you need to press the Ctrl+Shift+Enter three keys to end the formula when you want to display the value.

1.The cell is too small, and there are many digits to be displayed, the solution is to reduce the number of decimal places, such as keeping three decimal places;

2.The cell format is the default mode, changed to text mode.