Forum Discussion
Solved
Push in the right direction, pull multiple cells of data through lookup
Hello, I'm hoping someone might be able to help with my fairly basic excel competency. I have a table of data pulled from one of our systems that lists the names of courses along the top row of ...
Hi Kate,
If you are an Office365 subscriber you may use TEXTJOIN
=TEXTJOIN(",",TRUE,IF(C3:H3=1,$C$2:$H$2,""))That is an array formula.
Otherwise that could be UDF, please check for example https://www.get-digital-help.com/2010/12/20/excel-udf-lookup-and-return-multiple-values-concatenated-into-one-cell/
Hi Kate,
If you are an Office365 subscriber you may use TEXTJOIN
=TEXTJOIN(",",TRUE,IF(C3:H3=1,$C$2:$H$2,""))
That is an array formula.
Otherwise that could be UDF, please check for example https://www.get-digital-help.com/2010/12/20/excel-udf-lookup-and-return-multiple-values-concatenated-into-one-cell/
Fantastic thank you Sergei- that link gave me everything I needed.
Thanks again
Kate
