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...
Hi
I tested it and it works great on the sample workbook I attached.
However I cannot get it to work on my main workbook. On my main workbook I have different worksheets with the different data. Is there an issue with the functions you suggested when taking data from different sheets?
Thanks
I tested it and it works great on the sample workbook I attached.
However I cannot get it to work on my main workbook. On my main workbook I have different worksheets with the different data. Is there an issue with the functions you suggested when taking data from different sheets?
Thanks
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).