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.
Have you ever got into situation in office where you need to count the cells in Excel sheet with specific color? If yes then you can use following code which counts the number of cells…
How to Change TEXT into DATE Format Microsoft Excel “DATEVALUE” is the very useful where dates are available as TEXT and need to convert them to proper DATE format. DATEVALUE function helps to convert the…
MATCH function performs lookup for a value in a range and returns its position sequence number as output. It has two required and one optional arguments
“NETWORKDAYS” function is very helpful feature in the Microsoft excel to calculate the working days from a particular period excluding “Saturday and Sundays”. NETWORKDAYS function subtract the Start Day from the End Date provided.
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.
COUNT function is used to get the total count of Number values in range or list.COUNT Function has one required and optional arguments.