Forum Discussion
Formula for when one cell equals another cell & Resulting Cell is Yes
Need a formula of when one cell equals another cell (i.e. address), then the third cell automatically populates the text "Yes".
Example: A2 Cell equals B2 (A2 & B2 are address text content) which results in C2 being "Yes".
Thanks
Alternative to the previous suggestion if Excel version is below 2016.
=IF(A2=B2, "Yes", "")
You can use an IF formula in cell C2. This formula will check if the content of cell A2 is equal to the content of cell B2 and, if so, it will display "Yes" in C2. If the contents are not equal, it can display something else or remain blank.
This formula is simple and works perfectly for comparing addresses or any other text content in cells.
Maybe it will help you in addition to the previous suggestion.
Happy Excel-ing!
Alternative to the previous suggestion if Excel version is below 2016.
=IF(A2=B2, "Yes", "")
You can use an IF formula in cell C2. This formula will check if the content of cell A2 is equal to the content of cell B2 and, if so, it will display "Yes" in C2. If the contents are not equal, it can display something else or remain blank.
This formula is simple and works perfectly for comparing addresses or any other text content in cells.
Maybe it will help you in addition to the previous suggestion.
Happy Excel-ing!
- Thanks. This worked perfectly.
Take care.
- Try =EXACT(A2,B2) or =A2=B2
