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.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy