# Tag Archives | Array formula

## How To Find The Last Match In An Array Based On Multi Criteria Including Date In Excel

In this tutorial we’ll look at how to dynamically pull the salaries of all employees from a list, for the period of the date selected.

## How To Use An Array Formula To Match Values From Two Columns In Excel

In this video, we will look up two values in cells A1 & B1, find a match in two other columns of data and return a result from a third column from that same matching row. We will utilize the INDEX and MATCH functions while using Array formulas in the process.

## How To Find The Last Non-zero Number In A Column In Excel

Here is an array formula you can use to find the last non-zero entry in a column. We will use the IF and LOOKUP function in the process.

## How To Look Up Values Using The MAX & IF Function Combination In Excel

Here we are going to use the MAX and IF functions in combination to look up a value in an array. We will also incorporate the INDEX and COLUMN function to assist us…..

## Array Formulas With MIN And IF In #Excel

Here is an example of using the array formula process in Excel to determine the MIN number in a list…..

## How To Sum The Absolute Value Based On A Criteria In Excel

Here we are going to sum the absolute value of a list of numbers based on a criteria from another list in Excel: