Table of Contents
INDEX function in Excel can be used to return a value at the given position of a list or a table.
Lookup and reference
To choose a value from a list or array
Value at the given position
Index function has two forms
Array – The range of cells containing values.
row_num – The number of the row from which you want to return the value
col_num – [optional] The number of the column from which to return the value
area_num – [optional] Used to select the range in reference from which to return the intersection of row_num and column_num. The first area is numbered 1, the second is 2, and so on. Default value is 1.
INDEX function is often combined with MATCH function to create a powerful and flexible alternative to VLOOKUP function.