Forum Discussion
Solved
How to extract data from a column based on another column?
How can I use M in power query to extract data from column 'TB1' but only those sentences that are in column 'name'. I manually added column 'extract' so that it is clear what I mean.
pls try
pls try this
=Text.Combine(
List.Select(Search[name], (x)=> Text.Contains([TB1],x ,Comparer.OrdinalIgnoreCase)),", ")
Unfortunately, it doesn't return what I need. If I use the LOOKUP(2^99,SEARCH($E$2:$E$10000;A2);$E$2:$E$10000) function in Excel, it will return the expected values, but I would like to have it in power query because I need to update the data sometimes.