INDEX Function (Gnumeric)
Learn the INDEX function in Gnumeric: Returns a reference to a cell from a defined range.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Gnumeric. How formula examples are checked
The INDEX function in Gnumeric is used for this task: Returns a reference to a cell from a defined range. Retrieve the third number from a vertical range.
This guide explains how to read the formula, reproduce a concrete example, interpret its result and recognize common input mistakes.
Syntax and arguments
The worked formula below shows the argument order used for this example. Consult the linked software-specific function reference for optional parameters and edge cases.
Gnumeric formulas normally use commas (,) between arguments. These examples are written for Gnumeric rather than copied unchanged from LibreOffice Calc.
Worked example
Use this small practice sheet for the ranges referenced in the formula:
| Row | A (Quantity) | B (Amount) | C (Category) |
|---|---|---|---|
| 1 | 1 | 10 | apple |
| 2 | 2 | 20 | pear |
| 3 | 3 | 30 | apple |
| 4 | 4 | 40 | pear |
| 5 | 5 | 50 | apple |
=INDEX(B1:B5,3)
Expected result: 30.
Why it works: Retrieve the third number from a vertical range. The specified sample table supplies the referenced cells.
Another practical example
Practice inputs: B1:B5 contains 10,20,30,40,50.
=INDEX(B1:B5,4)
Expected result: 40.
INDEX returns the content in the fourth position of the reference range: 40.
What to watch for
INDEX positions count from the start of the supplied range, not necessarily row 1 of the worksheet.
For LibreOffice Calc formulas, separators are commonly semicolons; the Gnumeric examples here use commas. The arithmetic or official reference supplies the expected result, but Gnumeric has not been executed for this review.
How to use it in your own spreadsheet
- Identify the cells or inputs that correspond to the sample values above.
- Enter the formula in an empty cell, changing the references or literal values to match your sheet.
- Compare the output with a manual check on a small known example.
- Extend the formula to a larger dataset only after you understand the result.
Common problems and practical checks
- Use the correct lookup column or return range, and use exact-match options where appropriate.
- Check for duplicate keys, leading spaces and numbers stored as text in lookup data.
- A pasted formula may produce an error when it uses the other program’s argument separator or unsupported options.
Related functions
Documentation and verification
- Gnumeric official function reference
- Gnumeric function catalog
- The function name was checked against the official reference. A comparable example passed in LibreOffice Calc 25.2, but the example was not executed in this application. Confirm on your installed version before depending on it.