Welcome! Register Now to Unlock Exclusive Excel TutorialsGet Started
- Exclusive Playlists
- Downloadable Videos
- No Ads!
- Exclusive Templates
Description: INDEX and MATCH is the better way to look up values in Excel. While VLOOKUP is a great function, INDEX and MATCH can do more. In this video post, we'll show you how to use INDEX and MATCH for advanced lookups. We'll also provide some examples of how to use this powerful combination of functions. Index and match is a more versatile function than VLOOKUP, so make sure you learn how to use it! Table Of Content 00:00 Introduction 01:35 Vlookup Function 06:58 Index Match Formula 10:40 XLookup Function 14:00 Conclusion INDEX and MATCH are two of the most powerful functions in Excel. With INDEX and MATCH, you can do complex lookups that are not possible with the VLOOKUP function. In this article, we will show you how to use INDEX and MATCH to perform advanced lookups. The syntax of the INDEX and MATCH individual function is as follows: =INDEX(array,match_type,row_num) =MATCH(lookup_value, lookup_array, match_type) The INDEX function returns the value at the intersection of the row number and column number specified in the array. The MATCH function searches for a value in a table of data and returns the row number where that value is found. The INDEX and MATCH functions are often used together. The INDEX function returns a value based on the intersection of a row and column number from within an array, while the MATCH function searches for a specific item in an array and returns its relative position. The index is most useful when you want to return a value at a given location within a range, while Match is useful when you want to find the position of an item in a list.