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.
Excel Function COUNTIF COUNTIF Excel Function is also one of the most used function in excel. This helps the user to calculate the number of counts based on single logic given by the user. You…
RIGHT function is used for extracting the “Right Most” characters from the available string in Microsoft excel. Function returns value to new string.
SUMPRODUCT function performs multiplication of numbers within arrays and then sum the values SUMPRODUCT function has array1, 2.. arguments.
Microsoft Excel “HOUR, MINUTE, SECOND Functions” are time related functions helps to extract the Hour, Minute or Second from a complete Time.
An easy way to transform an array or range into a column with the TOCOL function. The ability to transpose data from columns to rows and in reverse has been in Excel for quite a…
In this guide, you will learn how to use the NPV function in Excel to calculate the net present value of an investment and how to avoid common mistakes when using NPV in Excel.