How to automatically fill in corresponding relationship data in excel

How to automatically fill in the corresponding relationship data in excel: first open the form and enter "=vlookup(A2,", select the area where the data is to be found; then change the formula to "=vlookup(A2, Table 2!$A $2:$B$17, 2, false)"; finally click the left mouse button to drop down and fill in.

The operating environment of this article: Windows7 system, Microsoft Office Excel2010 version, Dell G3 computer.

How to automatically fill in excel corresponding relationship data:

1. First open the Excel table that needs to be edited, click on the table, and enter in cell 1B2 “=vlookup(A2,”.

2. Then click to open Table 2 and select the area where you want to find data.

3. Then return to Table 1, change the formula to “=vlookup(A2, Table 2!$A$2:$B$17,2,false)”, return Click OK.

4. Then click the left mouse button to drop down and fill in the cells below.

Related learning recommendations: excel tutorial

The above is the detailed content of How to automatically fill in corresponding relationship data in excel. For more information, please follow other related articles on the PHP Chinese website!