Excel FunctionsLesson 88Free preview
INDEX
This lesson is part of Excel · All levels
Summary
INDEX returns the value of an array based on the number of rows and columns given. The syntax is. This function is very flexible because it can stand alone or be combined with MATCH for dynamic search.
Key points
- Syntax: INDEX(array, row_num, [column_num])
- The number of rows and columns is calculated relative to the array range
- For one column, the column argument can be passed
- Can restore entire rows or columns as a dynamic array
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.