How to use the Index function to find data?

November 15, 2021
101 Views 0

Graphic skills


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.

How to use the Index function to find data1.gif

Click Insert Function, input INDEX in search for a function and click OK.

How to use the Index function to find data2.gif 

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).

How to use the Index function to find data3.gif

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