How to use the INDEX function in excel?
1. Excel Index function as an array
The Index function is an array when the first argument of the function is an array constant.With this function, we have the following formula:
INDEX (Array, Row_num, [Column_num])
Inside:
+ Array: a range of cells or some required array of arrays.
+ Row_num: select rows in the array from which to return a value.
+ Column_num: select the column in the array from which to return a value.
Note readers must have at least one of the two arguments Row_num and Column_num
In the following example, we have the item name and the unit price of each item, find the unit price of the item knowing it's in row 2 column 2
Step 1:
In cell C7, you will enter the formula according to the above syntax, and then we press Enter to perform the Index function
E9: = INDEX (D5: E7,2,2)
Step 2:
Soon we will be returned to the position value E9 corresponding to the ceiling fan unit cost of 235000
2. Excel Index function as a reference
The Index reference function returns the reference of a cell at the intersection of a specific row and column.We have the reference Index formula as follows:
INDEX (Reference, Row_num, [Column_num], [Area_num])
Inside:
+ Reference: required reference region.
+ Row_num: the row number from which to return a reference, required.
+ Column_num: the column number from which to return a reference, optional.
+ Area_num: number of range will return the value in Reference.If Area_num is omitted, the INDEX function uses region 1, optional.
Step 1:
Also with the above Excel data sheet, we enter the formula as below.Then also press Enter.
Click at cell E9: = INDEX (D5: E7,2,1,1)
Step 2:
The result returned will be the name of the product type 'FAN CEILING'
=> Thus, there are 2 ways to use the INDEX function as array and reference form. Depending on the requirements of each article, the reader has a suitable way to use. Not too hard, right? In addition, you can combine the INDEX function with the MATCH function to be instructed in the following article of TipsMake
You should read it
- Index (INDEX) in SQL
- How to write the above index, below index in Excel
- Look up data in Excel tables: Replace VLOOKUP with INDEX and MATCH
- How to combine Index and Match functions in Excel
- Use Index in Access 2016
- How to use the MATCH function and combine the MATCH function with the INDEX function
- Instructions for indexing on the index on the index in Word
- 10 T-SQL Index statements needed with DBA
May be interested
- How to use the MATCH function and combine the MATCH function with the INDEX functionguide you to add a great search function followed by the match function and how to combine the match function with the index function.
- 3 ways to put abbreviations in WORD, EXCELinstead of having to sit down typing we can solve it by putting acronyms in 3 ways as detailed in the following article.
- 3 Steps to use Slide Master in Powerpointwhat is slide master and how to use slide master? the following article will guide readers specifically 3 steps to mastering slide master.
- The 10 most useful but often forgotten functions in excelmicrosoft excel is an extremely effective and effective calculation tool not only for accounting and office but also for many other industries.
- Did you know all the keyboard shortcuts from F1-> F12?notice that the top row of computer keyboards has keyboard shortcuts from f1-> f12 but rarely use shortcuts.
- Discover 6 features of Outlook mailmicrosoft outlook is currently a popular and widely used mailbox in many companies because of its ease of use and great management tools.