Forum Discussion

Anna Ianovskaia's avatar
Anna Ianovskaia
Copper Contributor
Jul 30, 2018
Solved

Need assistance with an excel formula

Hello! Hoping someone can help me out.

 

I have two worksheets side by side... One has a master list of all invitees, the one beside it has the list of confirmed registrants. I'd like to create a row in the master list with a formula that populates "yes" or "no" - "yes" if the registrants are in the first sheet, and "no" if they are not. I've tried the =IF formula but it seems to only be working for the first entry, so I must be doing something wrong.

 

Thanks in advance for the help!

excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 30, 2018

    Hi Anna,

     

    It could be like

    =IF(COUNTIF(<column with registrants names>,<invitee name>),"Yes", "No")

7 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 30, 2018

    Hi Anna,

     

    It could be like

    =IF(COUNTIF(<column with registrants names>,<invitee name>),"Yes", "No")
    • Anna Ianovskaia's avatar
      Anna Ianovskaia
      Copper Contributor
      Jul 30, 2018

      Hi Sergei,

       

      Thanks for your reply - so it would have to be done for each individual invitee? When I try to drag the formatting down the column, it does not work..

Resources