Lookup Value from 2 Columns and then use the IF Function

Hi All,

Please bare with me as this is my first post and not sure if the answer to this is somewhere else in the forum.

I have a table of data for which i am trying to find a certain outcome and upon finding the outcome returning a simple "Yes" or "No" outcome.

I believe it something to do with a VLOOKUP and an IF function but having no luck with this.

I am trying to use find a function that i can use where i locate a client's name from a list where it could contain their name multiple times in the same list to then look into another column to see if that client has been seen by one of members of staff then return an outcome if they have or not been seen.

For Example;

Client Name	Client Seen?	Date Seen
John Smith	No
Tracy Spears	No
John Smith	Yes	19/06/2016
John Smith	Yes	25/02/2016

In the above example you can see the name John Smith appears multiple times in the table.

I have another table that has a clean list of client names (No Duplicates) and i am trying to compare this list with the above table to find out if that person has been seen and if so return a "Yes" value or return a "No" value if they have not been seen. When i use the VLOOKUP function this only returns the first value it finds in the list which is not what i am after.

I hope the above example is clear in what i am trying to achieve.

Any help on this matter would be extremely useful.

Many Thanks in Advance

Try

=IF(COUNTIFS(A:A,"John Smith",B:B,"Yes")>0,"Yes","No")

Thanks for the quick response and yes that has worked a treat.

I think i was trying to overcomplicate the issue and just needed a 2nd pair of eyes to see where i was going wrong.

Can't believe i didn't think of this solution sooner.

Many Thanks again.

You're welcome.