Return Yes or No Based on Cell Data from Another Sheet
I Have Two Sheets. the First Sheet "Example A" and the Second Sheet "Example B". Example a Has a Master Sheet of Clients That May Also Be on Example B. If the...
I have two sheets. The first sheet "Example A" and the second sheet "Example B". Example A has a master sheet of clients that may also be on Example B. If the client is listed on Example B, Example A, should return the word "Yes", if it is not on Example B, it should return "No".
Any help would be appreciated.
2 Answers
Use MATCH() which will return a number if found and an error if not.
Using ISNUMBER() we can get a TRUE/FALSE
=IF(ISNUMBER(MATCH(A1,'Example B'!A:A,0)),"Yes","No")
Try this formula:
=IF(COUNTIF(B!$A$1:$A$5,A!A1)>=1,"Yes","No")
Table A:
Table B:
If your table is different, please provide the sample about your problem.
Marcus Vance is a cybersecurity auditor and technology writer dedicated to educating the public about online safety, data privacy regulations, enterprise security, and emerging cyber threats.
