Excel Help

Copper Contributor

I need your help

 

I need to copy & merge only text that matches a few conditions (equal to text) as long as "TRUE".

 

I tried using this formula:

AND([@Country]=table16[@Country], [@[Solution/ Product]]= table16[@[Solution /

Product]], [@[End User Type]]= table16[@[End User Type]]), TEXTJOIN(CHAR(10),,'Task Management - Public'!F2:F650), " ")

 

I also tried to use this formula:

=TEXTJOIN(CHAR(10),TRUE,IF(AND([@Country]='Task Management -Public'!A2:A7,[@[Solution / Product]]='Task Management - Public'!B2:B10,[@[End

User Type]]= table16[@[End User Type]]),'Task Management - Public'!F2:F10,""))

 

Unfortunately, It continues to copy text that not match the conditions ("False").

 

Could you help me Please?

 

Best Regards,

 

Tsvi Erenshtein.

1 Reply

@Tsvi1415 Please edit your question and remove your phone number and email address. You're practically inviting spammers to use your personal data.

 

Can you post a sample file and explain with some data what you would like to achieve? Looking at formulas that don't work is not really helpful in understanding your data or your desired result.