Aug 05 2020 10:59 AM
I created a form to use as a check off items completed. A lot of the items will have more than 1 response, I am trying to use a formula to place multiple names from the responses to one cell on the master check off sheet. Using the Index, match, formula I can only get one name cause I am guessing it based off the intersection of row and column.
Aug 06 2020 06:53 AM
INDEX/MATCH, VLOOKUP, etc return only first found value. To return multiple values FILTER or other functions could work. Better to have a sample to be more concrete.
Aug 06 2020 08:30 AM
Thank you for your response. Using the formula
=IF('Post Ops Data'!$F$2:$F$4="Completed 1.0 hr",'Post Ops Data'!$E:$2:$E$4,"NA")
I seem to get the results that I am looking for except for the fact that the formula is in A7 and the results returns in A7,A8,A9, and I need them to be for example A7 should display Joe, NA, Rickey instead of A7 Joe A8 NA A9 Rickey. Any help would be greatly appreciated @Sergei Baklan
Aug 06 2020 08:35 AM
SolutionI guess you need to wrap it with TEXTJOIN like
=TEXTJOIN(", ",1,IF('Post Ops Data'!$F$2:$F$4="Completed 1.0 hr",'Post Ops Data'!$E:$2:$E$4,"NA"))
Aug 06 2020 08:46 AM
Thank you so much that was exactly what I needed.@Sergei Baklan
Aug 06 2020 08:35 AM
SolutionI guess you need to wrap it with TEXTJOIN like
=TEXTJOIN(", ",1,IF('Post Ops Data'!$F$2:$F$4="Completed 1.0 hr",'Post Ops Data'!$E:$2:$E$4,"NA"))