The method for excel to match the corresponding project data: first open the Sheet2 worksheet of EXCEL; then insert the Vlookcup function and enter [=VLOOKUP(B2,Sheet1!$B$2:$C$4, 2,0)】;Finally confirm and drop down to fill in.
How to match the corresponding project data in excel:
1. Open the Sheet2 worksheet of EXCEL.
#2. Click above to insert a function, and then insert the Vlookcup function.
3. Fill in the form as shown below or directly enter =VLOOKUP(B2,Sheet1!$B$2:$C$4,2,0) in cell C2.
(The data in the first cell represents the cell you want to find, the data in the second cell represents the corresponding table range you want to search, and the third cell represents the data column to be returned.)
#4. Click OK and just drop down to fill in.
Related learning recommendations:excel basic tutorial
The above is the detailed content of How to match data of corresponding projects in excel. For more information, please follow other related articles on the PHP Chinese website!