
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!
Statement:The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn