Thread: [Solved] Copying and Concatenating data in excel based on a value in another column
View Single Post
 
Old 10-16-2021, 07:17 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
FILTER and TEXTJOIN available to you?
Code:
=TEXTJOIN(" ",TRUE,FILTER(Sheet1!A1:A15,ISNUMBER(MATCH(Sheet1!B1:B15,{1,5,6,9},0)),"Not found"))
the numbers 1,5,6,9 in a range K7:K10:
Code:
=TEXTJOIN(" ",TRUE,FILTER(Sheet1!A1:A15,ISNUMBER(MATCH(Sheet1!B1:B15,K7:K10,0)),"Not found"))

If this is too simplistic, supply a workbook with what you're wanting rather than a picture of one.
Reply With Quote