excel if condition

ojmp2001 ojmp2001 121 Reputation points

I have a column A1 that contains peoples first and last names. I want columnB1 to contain a yes or no based specific people's name e.g., if ColA1 contains names such as John or Jane or Susan then ColB1 will have Yes else No

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,610 questions
0 comments No comments
{count} votes

Accepted answer
  1. Emily Hua-MSFT 27,456 Reputation points

    @ojmp2001 ojmp2001
    Please try to use Find function and Count function.

    For my simple sample, I use the formula =IF(COUNT(FIND({"John","Suasn","Jane"},A2)),"Yes","No"). More information, please refer to my screenshot below.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful