Because the cell format is text, set the cell format to normal, and then double-click the cell corresponding to this function to display the calculation results. Taking the function VLOOKUP as an example, the specific method is as follows:

1. Use the VLOOKUP function to refer the score of Zhang San to F2 cell, and the result of F2 cell shows = VLOOKUP (E2, a: b, 2,0);

2. Select column F with the left mouse button, then click the right mouse button and click Format Cell;

3. After entering the cell settings, you can see the text displayed in the cell format, and then click General/OK in turn;

4. Then double-click the next cell F2 and press enter;

5. After pressing Enter, F2 cell will display the result of formula reference matching 90, and then fill the formula down.