EXCEL Tips How do sheet1 reference data in sheetl2 work
Tools/Materials
1
Lenovo E480
2
window10
3
EXCEL11.0.1.11
Methods/Steps
1
Enter the data in sheetl1 in the excel table.
2
Enter the data required in sheetl1 tables in sheetl2 in an excel table.
3
Add the data in sheetl2 tables to the data in sheetl1. In order to be able to change the data in sheetl2,
4
The data in sheetl1 can also change at the same time
5
This article is an unauthorized grab from Experience
6
Select the black in the bottom right corner of cell E2 and pull down the copy formula.
7
In fact, the most difficult thing is to select the data table referenced in the red box. The number 0 in the table is absolute search, and if you replace it with 1, it means relative search.