The premise is that there is a column of data m in sheet 3, which corresponds to the ETMSCODE you need to find.
At the beginning, ETMSCODE is empty. Please click the first blank data position of the column (the position corresponding to the first column), and then open fx.
When VLOOKUP is opened, the first input box is lookup_value. Move the mouse to the INS_NAME column and click the corresponding first data, which will be entered into lookup_value. Lookup_value is equivalent to an index, and we use the data corresponding to INS_NAME as the index. (because there is INS_NAME in table 3)
Then the second entry in the function box is: Table_array, that is, according to the above index, find the corresponding fields (such as INS_NAME, INS_CODE, PROVINCE_NAME, TYPE) in the corresponding table. Click on Page 3 below to switch to Page 3 and select it. Click the title of the column where INS_NAME is in the worksheet (B in the figure). Without releasing the mouse, drag horizontally to the right until column M corresponds to ETMSCODE data. At this time, the right side of the mouse will show how many columns you have pulled, that is, how many columns from INS_NAME to m are set to n.
Then release the mouse and it should automatically return to page 2. If not, the mouse will manually click to return to page 2. Now that the first two input boxes of sheet 2 have data, enter the third one, Col_index_num. Obviously, col stands for column, and asks which column you want to enter in the column of ETMSCODE, which happens to be selected in table_array (that is, N column where M is located). Enter this n.
Enter false for the last range_lookup below to match the corresponding index column accurately (one-to-one correspondence).
Then click OK. . . You will enter the corresponding data in Table 3 of ETMSCODE.
However, if there is no data corresponding to ETMSCODE in sheet 3, it must be calculated in sheet 3 first. VLOOKUP can only transfer the data needed in other worksheets to the worksheet you use as it is.
I hope I can help you.