How to use the INDEX function in Excel
How to use the INDEX function in Excel
Learn how to use the INDEX function in Microsoft Excel. This tutorial demonstrates how to use Excel INDEX with an easy to follow example and takes you step-by-step through the different options when entering your formula.
INDEX Function (and sample data):
https://www.techonthenet.com/excel/fo…
Excel Tutorials:
https://www.techonthenet.com/excel/in…
Don’t forget to subscribe to our channel for more great Excel tutorials!
Visit us at: https://www.techonthenet.com
or follow us on:
Facebook: https://www.facebook.com/techonthenetcom
Twitter: https://twitter.com/tech_on_the_net
Pinterest: https://www.pinterest.com/techonthene…
Content
0.02 -> The INDEX function is another powerful
Lookup function in Excel
5 -> You can use the INDEX function
to return a value in a table
9.26 -> given a row and column number
within that table
12.96 -> The easiest way to understand
this function is to look at an example
17.24 -> So let's get started
19.6 -> Here we have a table of data
containing order information
23.84 -> Let's use the INDEX function to return
the value at row 1, column 1 within our table
30.54 -> To get started, let's enter
the INDEX command
34.388 -> As you can see the INDEX function
takes 3 parameters
39.02 -> The first parameter to enter is the table or source
of the data that the index function will use
45.4 -> You can provide either a range of cells
or a named range for this parameter
50.56 -> For our example, we will enter
the range of cells A2:D6
56.32 -> The second parameter we must enter
is the row position in the table
60.02 -> where the value you want
to lookup is located
62.98 -> It is important to note that this is the
relative row position in the table
67.98 -> and not the actual row number
in the worksheet
71.38 -> In our example, since our table
consists of cells A2:D6
76.38 -> row #1 would be cells A2:D2
80.162 -> row #2 represents A3:D3, and so on
85.229 -> Since we are looking for a value
located in row 1 of the table
89.54 -> we will enter a value of 1
for the second parameter
93.32 -> The third parameter is the column position in the table
where the return value can be found
99.56 -> Just like the second parameter, this value is
the relative column position in the table
104.54 -> and not the actual column number
in the worksheet
107.66 -> A value of 1 indicates the first column in the table,
a value of 2 indicates the second column, and so on
116.28 -> In this example, we will enter
a value of 1
119.8 -> to indicate that the value we want to return
is located in column 1 of our table
125.68 -> Now that we have entered all of
the INDEX functions parameters
129.26 -> let's complete the command
to examine the result
133 -> You should see the value 10247 appear
137.02 -> This is the value that is found at the intersection
of row 1 and column 1 in our table
143.44 -> This covers a simple example of how
to use Excel's INDEX function
147.82 -> If you would like to see
more examples of the INDEX function
150.92 -> or would like to download the sample data
we use for this tutorial
154.34 -> please visit our website at
TechOnTheNet.com
157.64 -> If you found it tutorial helpful,
please leave a like on this video
161.74 -> and don't forget to subscribe
to our YouTube channel for more great Excel tutorials
Source: https://www.youtube.com/watch?v=U6OMmXgAWJc