INDEX function



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:

Index

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.



 

Published by Cash Heaven

Excel Expert and Financial Analyst Excel / Google Sheets / Financial Modelling, Valuation and Analysis Effective communicator / High quality / Affordable / Reliable / Quick Turnover I've successfully completed over 200 financial modelling, valuation and analysis projects with start-up stage and corporate companies over the past 4 years. I love to solve problems, have an eye for design, and have built business excel templates. I fix Excel formulas in 10 minutes.

One thought on “INDEX function

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: