Returns a value from a table, given a row and column number.
Syntax
data_table: The cell range to test. E.g. A1:D8
row: Row number of the cell containing the value to return, in the given data_table. E.g. 3
column: Column number of the cell containing the value to return, in the given data_table. E.g. 1
Remarks
When the row or column value is given as zero, the function takes the entire column or row as the input respectively.
Examples
Formula |
Result |
=INDEX(A1:D8;3;1) |
Rolling Chairs |
=INDEX(A1:D8;4;2) |
280 |
=INDEX(A1:D8~C1:C8;4;1;2) |
$123 |
Possible Errors
Errors |
Meaning |
#N/A! |
|
#NAME! |
|
#VALUE! |
|
#REF! |
|
Similar Functions
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Write to us: support@zohoforms.com