You can use VLOOUP formula to extract the admission ticket number, ID number and other related information from the first table, and you can follow the following steps:

1. Select the cell to extract data (as shown in Figure B2), that is, edit it in the second table in the title;

2. Click fx in the taskbar, select "VLOOKUP" formula in the "Insert Function" dialog box that appears (you can't find it to search), and click "OK";

3. In the dialog box that appears, "Find Value" selects cell A2, which is the information you currently have (in the second table);

4. Then in the "Data Table" column, you need to jump to the first table and select columns A to B;

5. Fill in "2" in the column of "serial number" (because there is a 2 between column A and column B in the column of "data table"), fill in "0" for matching conditions, and then click "OK" to paste the formula downward to extract the information of the admission ticket number corresponding to the training name;

6. In the same way, the ID number can be extracted. It should be noted that columns A-C should be selected in the column of "Data Table" and "3" should be filled in the column number.

References:

Baidu encyclopedia -vlookup