How to use the Index function to find data?

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. 

Open the spreadsheet in WPS Office, select the cells that contain data, and click the Formulas tab.

Click Insert Function, inputINDEX in search for a functionand clickOK.

3. In the pop-up dialog box, there are four parameters: array, row number, Column number, and array number. The array requires you to input the data areas. In this case, we want to calculate the postage of area 4 and size 6. Select the area (B3: K12) here.

4. Row number tells which row your searching data is located, here we input 4. Column number tells which row your searching data is located, here we input 6 .

5. Array tells referenced cell area, which means the precedent of one or more cell areas. In this case, there is only one single area, it is unnecessary to be filled.

6.Click OK after completing the above operations, the formula is: =INDEX(B3:K12,4,6).

In this way, we can quickly find out that the postage for size 6/ area 4 is 10.5.