How the WPS table uses the index and match functions

The WPS table uses the index and match functions:

1, we edited a company personnel travel the approximate cost table, we choose the query use.

2, this time we enter our function: The first one is to enter the array we want to query

3, select the numerical data inside, use the match function to pick out the selected data.

4, later in the selection to use the match function to find the area. Here we use the exact lookup.

5, this time we move out of the cursor to the following input English comma, and then enter match to find another data. The format is basically the same.

6, the last function we completed as shown in the following figure, the function is: =index (I23:j25,match (h30,i22:j22,0), MATCH (i30,h23:h25,0))

7, we can also set up linkage to use more convenient, select the data inside the data validation sequence.

8, we set the sequence to 2, one is domestic and foreign, a ticket and so on.

9. After quoting these, we click the inverted triangle to pull down the selection.

10, random transformation we can find out the different circumstances of the cost of expenditure.