Forum Discussion
Solved
Using IF(AND) inside TEXTJOIN array -- why is this not working??
Hi there! I'm trying to filter and show selected results from a table on another sheet, based on 3 parameters (something that is insanely easy on googledocs with the filter() function, which doesn't ...
AND returns a single TRUE or FALSE value, not an array. Try
=TEXTJOIN(" ,",TRUE,IF((Records!D$6:D$6000=$C$15)*(Records!I$6:I$6000=K$3)*(Records!B$6:B$6000=J$3),Records!$C$6:$C$6000,""))
Confirm the formula with Ctrl+Shift+Enter to turn it into an array formula, otherwise it won't work as intended.
AND returns a single TRUE or FALSE value, not an array. Try
=TEXTJOIN(" ,",TRUE,IF((Records!D$6:D$6000=$C$15)*(Records!I$6:I$6000=K$3)*(Records!B$6:B$6000=J$3),Records!$C$6:$C$6000,""))
Confirm the formula with Ctrl+Shift+Enter to turn it into an array formula, otherwise it won't work as intended.
HansVogelaar AH THANK YOU! This works. I'm endlessly grateful.
