Documentation/How Tos/Calc: INDEX function

CALC FUNCTIONS

Spreadsheet Functions

< Previous Section

Next Section >

FUNCTIONS

Spreadsheet Lookup functions

• Address
• Choose
• Hlookup
• Index
• Indirect
• Lookup
• Math
• Offset
• Vlookup

Spreadsheet Information functions

• Areas
• Column
• Columns
• Errortype
• Info
• Row
• Rows
• Sheet
• Sheets

Other functions

• Dde
• Hyperlink
• Style

< Previous Page

Next Page >

INDEX

Returns a value from a table, given a row and column number.

Syntax:

INDEX(datatable; row; column; areanumber)

returns the value at position row, column in the range or array datatable.

If datatable has multiple ranges then areanumber specifies which is to be used. areanumber is optional and defaults to 1.

If datatable has a single column, this syntax may be used:

INDEX(datatable; row).

If datatable has a single row, this syntax may be used:

INDEX(datatable; column).

Example:

If cells B1, B2, B3 contain 5, red and 6 and cells C1, C2, C3 contain TRUE, 3 and blue:-

INDEX(B1:C3; 1; 1)

returns 5.

INDEX(B1:C3; 3; 2)

returns blue.

INDEX(B1:B3; 2)

returns red.

INDEX(B1:C2; 1; 2)

returns TRUE.

INDEX(B3:C3; 2)

returns blue.

Template:Documentation/SeeAlso