How to find data with the same name through vlookup function

How to find data with the same name through the vlookup function: 1. Open an Excel worksheet with duplicate data; 2. Select the "C2" cell, then select the insert function "fx", and then in the pop-up function Find "VLOOKUP" in the parameter; 3. Find the same data through the formula "=VLOOKUP(A2,A3:A14,1,0)=A2".

The operating environment of this tutorial: Windows 10 system, Microsoft Office Excel 2016 version, Dell G3 computer.

How to find data with the same name through the vlookup function?

Excel uses the vlookup function to find duplicate values ​​and duplicate items

1. Open an Excel worksheet. Suppose we have a data table as shown in the figure. The names in the table are Repeated.

2. Select cell [C2], then select insert function [fx], and find [VLOOKUP] in the pop-up function parameters, as shown in the figure

3. Set the parameter [Lookup_value] of the function VLOOKUP to the value [A2], indicating the field we want to judge. As shown in the figure

4. Set the parameter [Table_array] of the function VLOOKUP to the value [A3:A14], indicating the area we want to match. As shown in the figure

5. Set the parameters of function VLOOKUP [Col_index_num] to 1, [Range_lookup] to 0, and the formula configuration is completed. This formula means: The data in cell [A2] matches the data in the following cells [A3~A14]. If there is a value of [A2] in the following [A3~A14], [A2] will be returned.

6. After confirmation, add [=A2] after the generated function, and the entire function is [=VLOOKUP(A2,A3:A14,1,0)= A2], if the result is TRUE, it means that the cell is duplicated in the following data. As shown in the figure

#7. Finally, pull down the formula and copy it. The result is TRUE, which means there are repeated values ​​in the subsequent data. Complete the search for duplicate values. As shown in the figure

Related learning recommendations: excel tutorial

The above is the detailed content of How to find data with the same name through vlookup function. For more information, please follow other related articles on the PHP Chinese website!