In the past we’ve used the combination of INDEX and MATCH to extract the value of the intersection of a row and column of a data range. But there is more that you can do with this function combination, and we’ll look at those options in this tutorial.
Tag Archives | INDEX
In this tutorial we are going to use the MAX and IF functions in an array formula, along with INDEX and MATCH to extract the last date in a list of events that is less than a control date and the event related to that date.
In this tutorial we are going to see how we can create a list of worksheets in our workbook, automatically create a hyperlink to each worksheet and make it dynamic so that when we add or delete any worksheet, the hyperlinked list will automatically update.
In this tutorial we are going to see how we can use an array formula using IFERROR, INDEX, SMALL, IF and ROW functions to create a dynamic, filtered list without using any built-in Excel functions like Filter to accomplish this.
In this tutorial we are going to look at a typical INDEX / MATCH combination formula but with a twist that concatenates both the lookup values and the arrays that are being looked into, making it an array formula.
In this tutorial we’ll take a look at how to use an array formula utilizing INDEX, IF, SMALL and ROW functions to extract unique values from a large list into a table based on a specific criteria.