How to use the Index function to find data?
A free Office suite fully compatible with Microsoft Office
A free Office suite fully compatible with Microsoft Office
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.
Was this helpful?
Yes
No
Trending Tutorials
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to color cell based on value in Excel?
- 5. How to compare two excel sheets and highlight differences
- 6. How to add text to beginning or end of all cells in Excel