You can use the following formula in Excel to return Yes or No to indicate whether or not a given cell has a matching value in another range:

=IF(ISNUMBER(MATCH(C2,$A$2:$A$11,0)), "Yes", "No")

This particular formula checks if the value in cell **C2** exists in the range **A2:A11**.

If it does exist, then the formula returns **Yes**.

If it does not exist, then the formula returns **No**.

The following example shows how to use this formula in practice.

**Example: If Match Then Return Yes or No in Excel**

Suppose we have a list of basketball teams in column A and we’d like to check if each specific team in column C belongs to the larger list in column A:

We can type the following formula into cell **D2 **to do so:

=IF(ISNUMBER(MATCH(C2,$A$2:$A$11,0)), "Yes", "No")

We can then click and drag this formula down to each remaining cell in column D:

Column D now returns “Yes” or “No” to indicate if each team in the **Specific Teams** list belongs in the **All Teams** list.

For example:

- Mavs belongs in the All Teams list so the formula returns
**Yes**. - Hornets does not belong in the All Teams list so the formula returns
**No**.

And so on.

Note that this formula is case-insensitive.

For example, if cell **C2** contained “mavs” then the formula in cell **D2** would still return **Yes**.

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

Excel: How to Use IF Function with INDEX MATCH

Excel: How to Use SUM with INDEX MATCH

Excel: Use INDEX and MATCH to Return Multiple Values Vertically