How to associate sheet1 and sheet2 in excel?

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

##2. Select cell B3, right-click >Copy;

See Figure 3

3. Select the cells in the table that need to be automatically filled with data, right-click, and under "Paste Special", select: fx icon;

See the picture 4

4. The actual effect

See Figure 5

6. In the table Enter any number in other cells in column A, and the corresponding cells will be automatically filled in with relevant data.

See Figure 6

##

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!