How to match data in 2 excel tables

How to match data in two excel tables

Match the gender in one table to the gender in the overall evaluation table middle.

Recommended: "Excel Tutorial"

Place the cursor in a cell, as shown in the picture.

Enter "=vl" in the cell.

Click on the blue mark in the picture.

The interface shown in the picture appears.

Click on the name of the student whose gender you want to match, and then add a "," after the data.

In another table, select all the data.

#Fill in the data that appears in Sheet1 in the overall evaluation table.

Since the data that needs to be matched is in the second column of Sheet1, add ",2," after the data (where "," is a comma in English), Then click Enter.

Completes one line of gender matching, as shown in the picture.

So that all genders are matched, as shown in the picture.

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