Data referencing column A in table 1 can be entered into cell a2.
=' 1'! Aortic second sound
Among them, the name of the table is in English single quotation marks, and the name between the table and the cell is in English! Separate it.
Excel references between different files. In English brackets? [? ] to reference the file. For example, if we save the file we are working on to drive D, the default name is book 1.xls? Create a new excel file and reference the data in the first column of the book 1.xls file:
=[book 1.xls] 1！ Aortic second sound
What are the single quotation marks in English and Chinese in this example and the above example? ? Yes or no, but excel will add it by default. In addition, in this example, when we enter the formula and press Enter, excel will automatically add the file address. As shown in this example, it may become:
='d:\[book 1.xls] 1 '！ Aortic second sound
Well, the above details the use example of EXCEL data reference formula. I wonder if you know how to solve the problem we raised at the beginning of the article.