0
INDEX is one of Excel's functions. It returns a reference to a cell that lies in a specified row and column of a range of cells. There are two formats of the function, which are the Array Format and the Range Format of the function. You can use it to find a value from a list. Here is a very simple example, where the function takes the value in the third cell in the range A5 to A15, which is a single column. The value that is in cell A7 would be returned in this case.
=INDEX(A5:A15,3)
A more complex version can get a value from a table. The following example will take the value from the cell in the range B8 to F30 that is at the 4th row and 2nd column.
=INDEX(B8:F30,4,2)
It can also be used to get values when more than one range is specified. This is the Array format of the function. The ranges are listed inside brackets. Here it gets the value in the 3rd row and 5th column from the 2nd range that is specified.
=INDEX((A7:F15, K11:M20),3,5,2)
It is a complicated but very powerful function, so it is worth trying to get used to using it.
Wiki User
∙ 8y ago
Wiki User
∙ 12y agoINDEX is a function in Excel to allow you to get values from a range of cells. You can get the value by its row within the range as follows. If you have a list of 5 numbers from cells A2 to A6 =INDEX(A2:A6,3) would give you the third number in the list. You can also get a value by its row and column in the range. If you have a list of 25 numbers from cells A2 to A6 =INDEX(A2:E6,2,1) would give you the number in the second row and first column.
Add your answer:
Earn +20 pts
Is there a function in Microsoft Excel where you can type a name or number you are searching for in the document and Excel will find it for you?
Try looking at SEARCH or INDEX in the help file.
What does Excel spredsheet mean?
there the different pages you have in excel
How do you Calculate Stock Beta in Excel?
You need to use the variance and covariance functions in Excel 1. Calculate the covariance of the stock returns with respect to an index 2. Calculate the variance of the index 3. Divide the first number by the second. See the related link for a spreadsheet
What is body index?
I think you mean Body Mass Index...?
What is the vertical line in excel chart that runs top to bottom?
It is the Y-axis or an index line, depending on where it is in the chart.
What is body mask index?
I think you mean Body Mass Index...?
What does indicator mean in excel?
cell
What is Microsoft Excel and other commonly used term in Excel?
Workbook Worksheet Vlookup Index Pivot Conditional formatting Table Sort Filter Cells Rows Columns are most common terms used in MS Excel Regards, Sarfaraz Ahmed http://findsarfaraz.blogspot.com
What does it mean cell colour Excel?
Cell color refers to the color of the square you have selected in Excel.
What does it mean if you see about getting excel in business?
Excel means egg cell or sperm cell.
Can you troubleshoot in excel?
Depends on what you mean by troubleshoot. Excel does have several auditing functions and error messages.
How do you get nse data in excel sheet?
hopefully your answer can be found hereExcel Tips and Tricks - How to Automatically Download Index Data from NSE - Part One
