{"id":5646,"date":"2021-05-11T14:13:36","date_gmt":"2021-05-11T14:13:36","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=5646"},"modified":"2024-03-29T14:06:07","modified_gmt":"2024-03-29T14:06:07","slug":"index-and-match","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/index-and-match\/","title":{"rendered":"Use Index and Match in Excel Table"},"content":{"rendered":"\n
If you have been using Excel at any point, you have certainly heard of the VLOOKUP<\/strong> function. Now, although this function is pretty valuable, there are two functions that combined together, are proven to be even more powerful and useful.<\/p>\n\n\n\n However, people tend to use them less, mostly because of the lack of understanding. These functions are INDEX<\/a><\/strong> and MATCH<\/strong><\/a>.<\/p>\n\n\n\n We will explain each one separately, and then, since they work best together, show their joint functioning. In the end, we will show the use of these functions to derive data from the table in a very simple way.<\/p>\n\n\n\n For our examples, we will use the list of Marvel movies that were released so far.<\/p>\n\n\n\n The Excel INDEX function returns the value at a given position in a range or array.<\/p>\n\n\n\n The syntax of this function is as follows:<\/p>\n\n\n\n Arguments are:<\/p>\n\n\n\n array<\/strong> – A range of cells, or an array constant. Don’t get confused by this. We will explain everything in an example. Let’s say that we have a list of Thor movies, their budget, and U.S. release date, like in the picture below:<\/p>\n\n\n\nIndex Function in Excel<\/h2>\n\n\n\n
=INDEX(array, row_num, [col_num], [area_num])<\/code><\/pre>\n\n\n\n
row_num<\/strong> – The row position in the reference or array.
col_num<\/strong> – [optional] The column position in the reference or array.
area_num<\/strong> – [optional] The range in reference that should be used.<\/p>\n\n\n\n