How to Use Index Function in Excel

How to use the index function in excel.
We use the Index function to return a value based on the row and column index number we provide. There are two parameter sets for the index function. Here is how the index function looks with each parameter set.
= Index( Array, Row Number, Column Number)
= Index( Reference, Row Number, Column Number, Area Number)
Let’s explain those parameters.
Array: This is where you specify the range. This range is where the index will find the row number and column number and then return the value of that specific cell.
Row number: Here, you will specify the row index number you need to extract the value from.
Column Number: Now, you should specify the column number. Once the index number gets a row and column number, it will return the value of the intersecting cell.
Now let’s explain the second set of the argument of the index function.
Reference: Here, you can select multiple ranges. Select a range and then add a comma and select another range. You must write those references within parenthesis; otherwise, it will count the second range as a row number and give you an error.
Row number: Here, you will specify the row index number of which you need to extract the value.
Column Number: Now, you should specify the column number. Once the index number gets a row and column number, it will return the value of the intersecting cell.
Area Number: Here, you have to select which range you need to extract from. It will be 1/2/3 ….. based on the order you followed in the reference section.
Once you provide all those parameters, the index function will return you the value of the intersecting cell.
This is how we usually use the index function. In a future tutorial, I’ll show you how to use the index and match function combinedly.
#Index #Function #Excel

Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media: