Forum Discussion
XLSX xlookup to Search for a word/phrase return matches
Hello! Disclaimer: It's been years since I have worked in excel and desperately need help. I have a spreadsheet (example below) where one column has paragraphs of text (Column C - "3rd Party De...
Perhaps
with
=IFERROR(
TEXTJOIN( ",", 1,
FILTER( $A$2:$A$7,
MMULT(--ISNUMBER( SEARCH( IF( ISBLANK(D2:F2), UNICHAR(9999), D2:F2), $B$2:$B$7) ),
{1;1;1} ) ) ),
"")