# Google Sheets Formula: If Match then Return Yes or No

You can use the following formula in Google Sheets 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\$12,0)), "Yes", "No")`

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

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 Google Sheets

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\$12,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:

• Thunder 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 you could also return a blank value instead of “No” if you’d like by using the following formula:

`=IF(ISNUMBER(MATCH(C2,\$A\$2:\$A\$12,0)), "Yes", "")`

The following screenshot shows how to use this formula in practice:

If a team name in the Specific Teams list does not belong in the All Teams list, the formula now simply returns a blank value.