Forum Discussion
Issue with Textjoin, multiple criteria. IF/AND function
Hi I have attached an example workbook with some example data. My goal is for someone to type in the product and the company category and be given a list of companies that match those two cri...
Different worksheet it not a problem. Most likely you have more than four companies. Then you have to adjust this part: {1.1.1.1} - which is for four companies (or four columns).
Does the position of the Categories matter. I can't understand why it works every time in the example workbook, but I get #value everytime I try in my main one.
=TEXTJOIN(", ",TRUE,IF(MMULT({1,1,1,1},(A37:AD584=A4)*(A35:AD35=C2)),A36:AD36,""))
This is what I am trying to do. Assuming the data is where the formula says, is there any reason this shouldn't work? I tried it with 30 x ,1 but that didn't help.
Thanks again
=TEXTJOIN(", ",TRUE,IF(MMULT({1,1,1,1},(A37:AD584=A4)*(A35:AD35=C2)),A36:AD36,""))
This is what I am trying to do. Assuming the data is where the formula says, is there any reason this shouldn't work? I tried it with 30 x ,1 but that didn't help.
Thanks again