technology

1855Currently online
141Today's Reading
44Share Today
Multilingual display

EXCEL Tips How do sheet1 reference data in sheetl2 work

2018-04-16 03:12:46

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.

Recommendation