Method: First select the specified cell, click "Insert Function" at the top of the page; then enter "vlookup" in the pop-up window; then enter the value to be searched in "Find Value", "Data Table" Enter the range of the information table; finally enter the specified number in "Column sequence value", enter "false" in "Matching condition", and click "OK".
The operating environment of this tutorial: windows7 system, WPS Office 2019 version, Dell G3 computer.
We open the excel table. For example, if we want to replace the letters in column A with the corresponding names, enter the information table in the blank area, with one column for letters and one column for names;
Place the mouse behind the cell to be replaced, click "Formula" - Insert function;
In the pop-up function window, we select, You can quickly find it by entering V in the input box and click OK;
Next set the function parameters, enter the value to be searched in the first column of lookup value, and In the second line of parameters, select the range of the information table. Note that you must add $absolute reference after selection. Enter 2 in the third line of col_index_num, and enter FALSE in the fourth line of parameters. Click OK to get the name corresponding to the letter A;
Finally, place the mouse on the lower right corner of the cell and drag it down to automatically replace the data in column A with column B.
Related learning recommendations: excel tutorial
The above is the detailed content of How to replace different content in excel at one time. For more information, please follow other related articles on the PHP Chinese website!