Does the Google Sheets formula return Yes or No if there is a match?

By /

The Google Sheets formula will return a Yes or No if there is a match based on the criteria set in the formula. If the criteria is met, the formula will return a Yes, indicating that there is a match. If the criteria is not met, the formula will return a No, indicating that there is no match. This allows users to easily identify and filter data based on specific conditions.

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:

Google Sheets if match then yes

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.

=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.

Additional Resources

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

x

Related terms:

  1. Excel Formula: If Match then Return Yes or No
  2. How do I create an [IF FUNCTION] to return [YES] or [NO] in [GOOGLE SHEETS]?
  3. Excel: Use VLOOKUP to Return Yes or No
  4. How can I use conditional formatting to highlight Yes/No values in Google Sheets?
  5. How to Match Two Columns and Return a Third in Excel
  6. How Can INDEX MATCH Be Used to Return the Maximum Value in Excel?
  7. What Does a High F Value Mean in ANOVA? what does the f value mean in anova
  8. Excel Formula: If Exact Match Then
  9. How to use Google Sheets: INDEX MATCH with Multiple Criteria
  10. What is the column number of a match in Google Sheets?