Google-sheets – Copying contents of cell in Google Sheets with IF statement

google sheets

I have Google spreadsheet which contains the names and email addresses of faculty members at my school. I am looking to be able to have the spreadsheet create a list faculty members that I choose. I have created a column with a simple drop down list (Yes or No) and would like to know if there is an IF statement, or some other command I could use which would do the following 'if any of the drop downs are toggled to 'Yes' then copy the email address in those rows to a single cell all separated by a semi colon'
Any help would be greatly appreciated.

enter image description here

Best Answer

Try this:H2:

   =ARRAYFORMULA(CONCATENATE(IF(B2:B10="yes",F2:F10&";","")))
Related Topic