Excel formula for comparing 2 columns

William Rainsford 20 Reputation points
2024-03-11T13:15:15.2266667+00:00

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.

Screenshot 2024-03-11 130949

Thanks

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,435 questions
0 comments No comments
{count} votes

Accepted answer
  1. Viorel 111.6K Reputation points
    2024-03-11T21:00:09.4033333+00:00

    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful