When we use the **IF function** for whatever reason, we need to have certain criteria that have to be met in order for our function to retrieve a proper value.

These criteria can be anything in our data.

Contents

## Find a Value in a List with If Function

There is one formula that can help us with finding a certain value in our list. For example, let us say we have a list of all the Marvel movies. Now, we want to make sure if Thor movie is on this list.

To do this, we will put a value: „Check if the value exists in a list“ in cell E2 and we will input the following function in the E2 cell:

`=IF(ISNUMBER(MATCH("Thor",A:A,0)),1,0)`

Our logical test for this **IF function** first checks if our value is equal to the „Thor“ value (**lookup_value** of our **MATCH function**). If it is, Excel will return value** 1**. If not, it will return the value **0**.

We will have a value of 1 returned since we have a Thor movie on our list.

## Get Results If Value Is in List

If we know what value we are searching for, we can combine various functions with our condition. For example, we can use the **SUMIF function** to find out the total revenues of Thor movies.

As we can see, we have a total of three Thor movies on our list. To sum all the revenues from these movies, we will input the following formula in cell **F2**:

`=SUMIF(A2:A24,"*Thor*",C2:C24)`

The **SUMIF function** returns the sum of cells in a range that meet a single condition.

We have three parameters for this function:

**Range.**Here, we type in the range from which we are searching for our condition. In our case, the range is**A2:A24**.**Criteria.**Our criteria are Thor movies. We want to include them all and we use “*” to make sure to include all the movies that contain this value, regardless of the text in front or after this value.**Sum_range.**In our final step, we have to specify what are the values that we want to sum. For us, these values are found in**column C**and we will input the range**C2:C24.**

Our final result will be just a little less than $2 billion.

## Formatting If a Certain Value Is in a List

There is also an easy way for us to highlight all the values in our list that have a certain value. We will use Thor movies again for our example.

To do this, we have to select **column A**, go to **Home >> Styles >> Conditional Formatting**.

In the **Conditional Formatting** dropdown menu, we select **Highlight Cells Rules** and **finally Text that Contains**.

Once we do all of this, we have to input Thor movie to clarify what we want to be highlighted.

We will choose **green fill with dark green text**, and we will see the changes in our table immediately. We click OK and have a result as follows: