Table of Contents
The use of an Excel formula allows for the quick and efficient determination of a “Yes” or “No” answer when searching for a specific match within a dataset. By utilizing this feature, users can easily identify the presence of a desired element and streamline their data analysis process. This function is particularly useful for those working with large amounts of data, as it eliminates the need for manual searching and provides a concise and reliable answer.
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.
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: