Скачать с ютуб How to use Excel Index Match: the EASY way! (For Beginners 2024) в хорошем качестве

How to use Excel Index Match: the EASY way! (For Beginners 2024)

In this video I explain how to use the Excel INDEX MATCH formula the EASY WAY and as an alternative to VLOOKUP in Excel. This video will help breakdown this in for beginners in 2021. I explain the two main benefits of INDEX MATCH over VLOOKUP and HLOOKUP. This includes: The ability to return a value from a column to the left/above. Separate columns for the lookup and return ranges. We also look at the most common error that the formula returns and how to prevent it. Index explained: The first argument of INDEX is to give it an array. This array (range) should include your answer. You then need to specify how many rows to go down and how many columns to move to find the correct value. You cannot move outside the INDEX range. The syntax of INDEX is: • The range where the return value resides. • Number of rows to move down (the row index) • Number of columns to move to the right (the column Index). This argument is optional. If you only have one column, you can leave the column argument empty, otherwise, you need to specify the number of columns to move over, in the range. The MATCH function’s syntax is as follows: • Like VLOOKUP, Match needs a lookup (target) value. The user can reference a cell or directly type the value into the formula. • Lookup_array: The “list” (range) where the return values are located. • Match_type: 0 for an “exact” match. Index MATCH used together: When INDEX and MATCH are used together, the MATCH function finds the look up value’s row / column index and then hands this value off to the INDEX function to get the lookup value. #MsExcel #Excel #Free #analysis #analysts #finance #budget