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
Tsvi1415
Occasional 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

@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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies