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.

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

Leave a Reply

Your email address will not be published. Required fields are marked *