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.
COLUMN function is used to get the column reference number of the excel worksheet. COLUMN Function has only one argument.
How to use Excel Function PROPER? PROPER function is used for changing the format of any text or string to PROPER or SENTENCE Case. PROPER Function has argument only one argument i.e. text, which makes the function…
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…
COUNTIFS function is used to get the total count for number of times the various criteria across ranges are met.
LEFT function is used for extracting the “Left Most” characters from the available string. The output of the function returns the extracted characters in new cell
SUBSTITUTE function is used to substitute the existing old text to new text.