How to make "Advanced filter" look up function in WPS table

Source: Internet
Author: User

As shown in the picture, if you want to find "Wu Shan Audio Shop" "Hua du curtain Supermarket" corresponding "bank" "Account" what do you usually do? is not the first time to think of the search function vlookup This function to show it? In fact, you can also use advanced screening to do so, a simple few steps can be achieved, follow me to do it!

1. Open the worksheet you want to edit, and set the content you want to find on the same worksheet.

2, according to the position shown below, click [wps Form] drop-down menu.

3, as shown in the following figure, select the [ data] command [filter] , select [Advanced Filter] , click the mouse.

4. When you open the Advanced Filter Dialog window, in the mode bar, select Copy filter results to another location.

5. Next, fill in the contents of the "list area" criteria range "copy to" three boxes. List area is the area where you want to fill out the filter. As shown in the following illustration, we filter all the cells in the worksheet.

6. In the Condition area box, fill in the cell where we want to find the content.

7. Copy the composite filter criteria content here.

8, after clicking the [OK] button, the result is shown in the following figure.

  Attention matters


Criteria range content must be exactly the same as the content you want to find to apply to this method, and if only a partial field query is not appropriate.

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: and provide relevant evidence. A staff member will contact you within 5 working days.