Scribd
Upload
59 views3 pages

Understanding the INDEX Function in Excel

The document discusses the INDEX function in Excel. It returns a value or reference from within a table or range. INDEX can return the value of a specified cell or array using the syntax =INDEX(array, row_num, [column_num]). It can also return a reference to specified cells using the syntax =INDEX(reference, row_num, [column_num], [area_num]). The MATCH function searches for an item in a range and returns its position, which can then provide the row_num argument for INDEX.

Uploaded by

Julius Cabingan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
59 views3 pages

Understanding the INDEX Function in Excel

The document discusses the INDEX function in Excel. It returns a value or reference from within a table or range. INDEX can return the value of a specified cell or array using the syntax =INDEX(array, row_num, [column_num]). It can also return a reference to specified cells using the syntax =INDEX(reference, row_num, [column_num], [area_num]). The MATCH function searches for an item in a range and returns its position, which can then provide the row_num argument for INDEX.

Uploaded by

Julius Cabingan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Before we proceed to the next topic, let me introduce myself, I'm julius U.

Cabingan and I came from


bsmt block 1b7. so let's discuss the index function

The INDEX function returns a value or the reference to a value from within a table or range. You can use
INDEX function in two ways −

• Ø To return the value of a specified cell or array of cells.

• Ø To return a reference to specified cells.

Things to remember when Using INDEX function to return the value of a specified cell or array of cells

The function returns the value of an element in a table or an array, selected by the row and column
number indexes.

Use this if the first argument to INDEX is an array constant.

Syntax: =INDEX (array, row_num, [column_num])

In the table below, you can see all the Arguments of the excel or references and its description. you can
see the array, row_num, and column_num

Things to remember when Using INDEX function to return a reference to specified cells

The function returns the reference of the cell at the intersection of a particular row and column. If the
reference is made up of nonadjacent selections, you can pick the selection to look in.

Syntax: =INDEX (reference, row_num, [column_num], [area_num])

In the table below, you can see all the Arguments of the excel or references and its description. you can
see the reference, row_num, column_num and area_num

5 secs

HERE ARE SOME OF THE EXAMPLE


Meanwhile, MATCH Function is a function searches for a specified item in a range of cells, and
then returns the relative position of that item in the range.
 Use MATCH instead of one of the LOOKUP Functions when you need the position of an item
in a range instead of the item itself. For example. you can use the MATCH Function to provide a
value for the row_num argument of the INDEX Function.
Syntax: = MATCH (lookup_value, lookup_array, [match_type])

So Our next slide is all about the Arguments of the excel or references and its description. you
can see the lookup_value, lookup_array, and match_type. 

Here are some of the example

You might also like