# Tag Archives | IF

## 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 Randomly Pair Teams From Different Countries In Excel

In this tutorial we’ll look at how to randomly pair two teams from a list of 10, five from each of two countries, but with the condition that we can’t pair two teams from the same country. We’ll use IF, RANDBETWEEN, and CHOOSE functions to accomplish this. Here we go!

## How To Determine If A Series Of Requirements Are Complete Using IF and SUMPRODUCT In Excel

In this tutorial we are going to use the IF and SUMPRODUCT functions to determine if a series of courses or requirements have been completed for a student or employee. We will also use Conditional Formatting to make the results more visual.

## Two Numbering Techniques For Counting And Labeling Lists In Excel

In this tutorial we are going to look at two methods of labeling or numbering accounts, locations, inventory, etc. using IF statements and Custom Formatting to count the frequency in a list or label the items in a sequence.

## 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 Do A Lookup In Excel Of Unique Values In A Table That Has Several Of The Same Items

In this tutorial we are going to do a lookup from one table that has multiple quantities for the same items, and ensure that we only pull each unique quantity once into another table sorted in a different order.