![INDEX Function.png](https://images.hive.blog/DQmPxoSeducfKAJmbikdYLRJtxKrea8K1jfVJPPChSpU2MJ/INDEX%20Function.png)
**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:
![image.png](https://images.hive.blog/DQmY1AWJmoQZJ6p3oiRdSCsipe3RZmhqEkdc11mf9Kd3A4b/image.png)

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](https://www.fiverr.com/share/ey8E6m)
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](https://leopedia.io/hive/) in 7 days while blogging your favorite topics, join us here at [Peakd](https://peakd.com/register?ref=cashheaven). 
*Thumbnail used is made in Canva.