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??
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
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
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks