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
Bookmarks