How to match two columns of data in excel

How to match two columns of data in excel?

Excel’s method of one-to-one correspondence between two columns of data

1. First, list the name and data columns in two Excel tables. You need to Match the data in Table 2 to the data in Table 1 based on name.

#2. Click "fx" to insert the function and select the "vlookup" function.

3. In the function parameters, enter the data in the format as shown below, and convert it into the formula: =VLOOKUP(A2,$D$2:$E$8,2,0 ).

#4. Click OK and pull down the formula to enter data according to the name of Table 1 corresponding to the data in Table 2.

Recommended: "excel tutorial"

The above is the detailed content of How to match two columns of data in excel. For more information, please follow other related articles on the PHP Chinese website!