Function Type: Lookup and Reference
Description:
INDEX function returns the value of a given location in a table range or array. This function is commonly used with MATCH function which give us the location of the lookup_value.
Function Structure:
=INDEX(array, row_number, [column_number])
Argument Breakdown:
array - This is the group of cells where your excel will look into.
row_number - This is the row location in your array. This argument requires a number input. A function that returns a number such as MATCH can also be used here.
[column_number] - This is the column location in your array. This argument requires a number input. A function that returns a number such as MATCH can also be used here.
Example:
Say we want to look into the Price of the Tool Box, The formula will be
=INDEX(A2:C8,6,2)
This means that Excel will return the value in the intersection of 6th row and 2nd column of the array A2:C8.
To make it more dynamic like a vlookup, we can pair it with MATCH function.
Still need help with Excel and Google Sheets?
Get Instant Expert Help
We can also accept LEO, HIVE, HBD tokens as payment.
This post is designated as a reviewer for Excel trainings I conduct.
Feel free to share with anyone. 馃槈
Earnings from Upvotes on this post are used to continue sharing Excel knowledge.
If you also want to earn HIVE in 7 days while blogging your favorite topics, join us here at Peakd.
*Thumbnail used is made in Canva.
