Concatenating If's

OK, L7 through L11 and O7 through O11 contains text
M7 through M11 and N7 through N11 contains a Data validation rule. The Value will be Yes or Blank

The user can select Yes in cells M7:M12 and/or N7:N12

I need to concatenate the values of the options they have selected.

=CONCATENATE(IF(M7="Yes",L7,IF(N7="yes",O7,IF(M8="yes",L8,IF(N8="Yes",O8,IF(M9="yes",L9,IF(N9="Yes",O9,IF(M10="yes",L10,IF(N10="Yes",O10,IF(M11="yes",L11,IF(N11="Yes",O11)))))))))))

This will only return the first value they selected yes for. If they select more than one by entering yes into more than one field, I need the text from L7 through L11 and O7 through O11 concatenated.

Michelle

Is there a reason why you post in the Outlook forum??

Wrong forum? So Sorry! I was in the Excel Workbook forum and had to refresh my browser because I stepped away for a while. I didn't realize ir placed me into another forum!

Closing this post, a new thread has been started