Recommended tutorial: "excel basic tutorial"
How to associate sheet1 and sheet2 in excel?
How to associate sheet1 and sheet2 in excel:
1. Enter the formula in cell B3 of sheet 2:
=IFERROR(VLOOKUP($A3,Table 1!$A$3:$D$6,MATCH(Table 2!B$2,Table 1!$2:$2,0),FALSE),"")
Enter ;
See Figure 1
##
The above is the detailed content of How to associate sheet1 and sheet2 in excel?. For more information, please follow other related articles on the PHP Chinese website!