INDEX function is used to get the value from a cell range or table, function returns the value from a table where row and column intersect with each other.
INDEX function has two Required arguments i.e. array, row_num and one Optional argument i.e. [column_num]. [column_num] argument is optional only if array argument contains one column.
=INDEX(array,row_num,[column_num])
array argument is used to give the cell range from which you want to get value
row_num argument is used to give the row number from which value is required
[column_num] argument is used to give the column number from which value is required. If array argument only has only one column, then [column_num] argument is optional
Here we have one example, where:
Here we have another example, where:
Here we have another example, where:
– If cell reference is not correctly provided in the function, then it may give output as Error.
– If output of the function is not as per the desired format then you may change the cell format to “GENERAL”
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
If you liked this article and want to learn more similar tricks, please Subscribe us.
SUM Function in Excel Excel is a mathematical spreadsheet where you can perform multiple calculations with the help of Excel Formulas. These are automated formulas which refreshes automatically once you refresh your data in a…
SUBSTITUTE function is used to substitute the existing old text to new text.
MIN function is used to get the smallest number in range or list of values.MIN function has one required i.e. number1 and optional argument i.e. [number2]
Excel Function ISERROR Microsoft Excel “ISERROR Function” is a Logical Function and it is used to check if cell contains any “ERROR”. “ISERROR Function” is used as a test to validate if cell contains any…
INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.
RAND AND RANDBETWEEN FUNCTION We have got many instances where we needed to generate a random database or values. “RAND function” is very useful for users who creates random database for various types of working…