Table of Contents
Excel is a powerful tool used to create spreadsheets and analyze data. One of the most useful features of Excel is the ability to use formulas to quickly and easily manipulate data. One such formula is the If Match then Return Yes or No formula. This formula allows users to quickly identify if a certain value is present in a range of cells and return a “Yes” or “No” result. This can be used to quickly and accurately identify data that meets certain criteria, saving time and energy during data analysis. This tutorial will demonstrate how to use this formula in Excel.
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.