How to use the Index function to find data?

November 15, 2021
2.6K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

A free Office suite fully compatible with Microsoft Office

Free Download

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

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.