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.
Using AND() you try to find values which at the same time are equal to $C$15, K$3, J$3. Obviously you have no such. Perhaps you mean OR condition?
SergeiBaklan Of course, that makes sense. But I do need all 3 conditions to be true, so I don't think OR() would work. But the other solution offered below works, hallelujah! Thank you!