Home

Excel Help

%3CLINGO-SUB%20id%3D%22lingo-sub-876136%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876136%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F414729%22%20target%3D%22_blank%22%3E%40Tsvi1415%3C%2FA%3E%26nbsp%3BPlease%20edit%20your%20question%20and%20remove%20your%20phone%20number%20and%20email%20address.%20You're%20practically%20inviting%20spammers%20to%20use%20your%20personal%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECan%20you%20post%20a%20sample%20file%20and%20explain%20with%20some%20data%20what%20you%20would%20like%20to%20achieve%3F%20Looking%20at%20formulas%20that%20don't%20work%20is%20not%20really%20helpful%20in%20understanding%20your%20data%20or%20your%20desired%20result.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-873788%22%20slang%3D%22en-US%22%3EExcel%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-873788%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20your%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20copy%20%26amp%3B%20merge%20only%20text%20that%20matches%20a%20few%20conditions%20(equal%20to%20text)%20as%20long%20as%20%22TRUE%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3EI%20tried%20using%20this%20formula%3C%2FU%3E%3A%3C%2FP%3E%3CP%3EAND(%5B%40Country%5D%3Dtable16%5B%40Country%5D%2C%20%5B%40%5BSolution%2F%20Product%5D%5D%3D%20table16%5B%40%5BSolution%20%2F%3C%2FP%3E%3CP%3EProduct%5D%5D%2C%20%5B%40%5BEnd%20User%20Type%5D%5D%3D%20table16%5B%40%5BEnd%20User%20Type%5D%5D)%2C%20TEXTJOIN(CHAR(10)%2C%2C'Task%20Management%20-%20Public'!F2%3AF650)%2C%20%22%20%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3EI%20also%20tried%20to%20use%20this%20formula%3A%3C%2FU%3E%3C%2FP%3E%3CP%3E%3DTEXTJOIN(CHAR(10)%2CTRUE%2CIF(AND(%5B%40Country%5D%3D'Task%20Management%20-Public'!A2%3AA7%2C%5B%40%5BSolution%20%2F%20Product%5D%5D%3D'Task%20Management%20-%20Public'!B2%3AB10%2C%5B%40%5BEnd%3C%2FP%3E%3CP%3EUser%20Type%5D%5D%3D%20table16%5B%40%5BEnd%20User%20Type%5D%5D)%2C'Task%20Management%20-%20Public'!F2%3AF10%2C%22%22))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EUnfortunately%2C%20It%20continues%20to%20copy%20text%20that%20not%20match%20the%20conditions%20(%22False%22).%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20help%20me%20Please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETsvi%20Erenshtein.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-873788%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Tsvi1415
Visitor

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
Highlighted

@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.

Related Conversations
IF statements and conditional formatting
clare1981 in Excel on
0 Replies
Reverse numbers and characters in worksheet
David_Gerrior in Excel on
0 Replies
Sumifs
Jsbluemoon82 in Excel on
3 Replies
Excel formula similiar to texjoin
Carlo74 in Excel on
0 Replies
everything is black and white in excel
Gold4trees in Excel on
1 Replies
Deleting unwanted rows and columns
chipg900 in Excel on
3 Replies