# Tag Archives | INDIRECT

## How To Use Conditional Formatting To Verify Selections Of A Drop Down List In Excel

In this tutorial we’ll see how we can use Conditional Formatting, using the ISBLANK, COUNTIF, and INDIRECT functions, to verify the accuracy of selections from a Data Validation drop down list in Excel.

## The Two Most Common Errors When Selecting Photos From A Drop Down List In Excel

I’ve done three posts in the past on how to select photos using a drop down list. This series has turned out to be my most popular of all my posts. With all the questions and comments I get, there are two issues that are the most common errors that folks commit when setting up […]

## How To SUM A Range Of Values In An Array Using INDIRECT, ADDRESS, and MATCH Functions In Excel

In this tutorial we are going to explore a variation of the traditional INDEX/MATCH combination to extract and sum only a portion of a row or column within an array.

## How To Repeat A Range Of Items Multiple Times In Excel

In this tutorial I’ve created a formula that can retrieve a list of items, repeat that list, and automatically adjust if items are added to or deleted from that list. You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner. […]

## How To Use INDEX and MATCH In A Table With INDIRECT In Excel

In this video we’ll look at the traditional data range lookup using the INDEX and MATCH functions, but add a twist to look up the values in a table, plus a bonus twist using the INDIRECT function.

## How To Create A Single Formula to Determine If All Parts Of A Project Are Complete In Excel

In this video we’ll create a single formula that can be copied down through thousands of rows that will determine if each student completed a varying number of components of a project. In the process we will use the AND, COUNTIF, IF, INDIRECT, MATCH, and VLOOKUP functions.