# Tag Archives | IFERROR

## How To Find The Last Match In An Array Using LOOKUP In Excel

In this tutorial we are going to use the LOOKUP function to find the last match in an array and return the corresponding value from another column from that row.

## How To Analyze Completed Projects Using A PivotTable In Excel

In this tutorial we’ll take a look at how to add a column with a formula outside of our PivotTable for project analysis that pulls results from a Table, then use Conditional Formatting to dress it up.

## How To Repeat Items In A List In Excel

Here is how you can take a list and create a formula to repeat the items in that list the given number of times you specify. We will use the IFERROR, ROUNDUP, INDEX and ROWS functions in the process.

## How To Calculate Multiple Date Gaps Between Events In Excel

Here is how to calculate the number of days between multiple events over a specified time period. In this process we will use the IF, IFERROR and LARGE functions and utilize Array formulas.

## How To Retrieve Multiple Lookup Values In Excel

Let’s take a look at how we can retrieve multiple results from a table based on a single selection using an array formula. In the process we will utilize Array formulas and the functions IF, IFERROR, INDEX, LOOKUP, ROW and SMALL.

## VLOOKUP With A Couple Twists In #Excel

Here are the basics for using the VLOOKUP function in Excel, with a couple helpful tips…..