# Tag Archives | Array formula

## Some Unique Uses of INDEX and MATCH Functions In Excel

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.

## How To Find The Last Date Less Than A Control Date In Excel

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.

## How To Extract A Dynamic List From A Data Range Based On A Criteria Without Filters In Excel

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.

## Two Methods To Extract Multiple Columns With VLOOKUP In Excel

In this tutorial we are going to look at two ways of using VLOOKUP to pull data from a range of multiple columns at one time. One option will utilize an array formula using an array constant.

## How To Lookup Multiple Criteria Using VLOOKUP In Excel

In this tutorial we are going to look at how you can have multiple criteria as your lookup value with VLOOKUP. We’ll use the CHOOSE function with an array constant, and enter it as an array formula.

## How To Use INDEX & MATCH Functions With Concatenated Values In Excel

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.