Excel formula for comparing 2 columns

William Rainsford 20 Reputation points


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


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

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


    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