# Tag Archives | MATCH

## How To Do A Reverse Lookup Using OFFSET And MATCH In Excel

In this tutorial we are going to look at how we can do a lookup in an array by looking up the values in the far right column and returning the result from a column to the left. We are going to use the OFFSET and MATCH functions to accomplish this.

## How To Create An Error Message When Using Dynamic Data Validation In Excel

When using dynamic Data Validation, there are points when the item shown does not match the category listed> In this tutorial, I’ll show you how to write a formula to advise the user that another item needs to be chosen. We’ll use four functions to accomplish this: IF, OFFSET, MATCH and COUNTIF.

## How To Create A Simple Sales Evaluation Dashboard In Excel

In this tutorial we’ll take a look at how to create a simple dashboard using a combo box, a chart, an INDEX/MATCH combination formula and a few simple formatting concepts to easily evaluate the sales for any individual salesperson.

## 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 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.

## You Need To Change How You Think When Using Formulas In Conditional Formatting!

I recently received a request to use Conditional Formatting when performing two different comparisons on two data ranges.  How I approached the task was WRONG! Read on to see how I finally got myself on the right track.