Excel formula for comparing 2 columns

Question

Hi,

I have a task that involves recovering software licences for users who no longer work at our company.

I've got a list of emails of disabled user accounts and a list of licencees, also emails. Despite extensive searching, I couldn't find the correct excel formula to use, also tried out using conditional formatting. The formula needs to compare a user's email from Column D and look anywhere in column C for a match, then return the result to Column E.

Thanks

Answer 1

If the first email is in A2, then try to enter this formula to C2:

=IF(B2="","",IF(ISNA(MATCH(B2,A$2:A$9,0)),"no","yes"))

If it works, then copy the formula (using fill handle) to the other cells.