How does the data in an Excel table implement a quick query?

Source: Internet
Author: User

How does the data in an Excel table implement a quick query? Sometimes we need to query the data in multiple workbooks, and a manual click and record it will be cumbersome, here's a simple way.

1. First, we open a work sample form as an example.

2, here is a salary table, if we need to compare someone to the three-month payroll, the normal operation is to open each salary sheet, and then the data recorded in the comparison. Such a way is very cumbersome. Of course we can also use formulas to work with thin references.

3, if the work is more thin, then we need to use the formula function to query, and we need to first on the workbook name uniform naming. We set the workbook name uniformly in a separate column and then use the indirect function to edit it. function formula is =indirect (table_array& "!sheet")

4, if such a fill error occurs, please note that the list cell values are the same as the workbook name, sometimes we re-edit the workbook name with a half corner space, it is difficult to find.

5, in fact, we have a more simple way, is to use the monitoring point in Excel function. In the Formula tab panel, click the Monitor Shortcut button, and in the dialog box that pops up, we select the corresponding data cell that needs to be queried.

6. After all the data cells that need to be queried are fully added, the relevant data is clearly arranged in the monitor panel, and the final result is the same as the formula used.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.