# Excel Formula: If Match then Return Yes or No

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.