Partial match from 3 column with text

PaulinaMaj123 ,

You can accomplish this using Power Query. 

1) Split column 1 using the comma as a Delimiter

2) Then add a Custom Column which searches in Column 2 for any of the values in the columns created by the Delimiter

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WilDSUTI0BBIgRkHi0V0pVZmpRXmZ2UCugaGeoYGekYGREQpHwcjAytTcysBAB03MAouYJVCMCN2GWHQbQnXH6kCcCXYGFmcamSE5E8FRMDK2MjQGGYomZgJxErKoER6VIOtxWGyJbDGco2BgYWVoADYOVcwQi5gR1DGoosbE6Lakiu7YWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Place = _t, #"Worker code" = _t, Zespół = _t, Month = _t, Date = _t, #"1" = _t, #"2" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Place", type text}, {"Worker code", type text}, {"Zespół", type text}, {"Month", type text}, {"Date", type text}, {"1", type text}, {"2", type text}}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "1", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"1.1", "1.2", "1.3"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"1.1", type text}, {"1.2", type text}, {"1.3", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type1", "Match", each if Text.Contains( [2], [1.1] )
or Text.Contains( [2], [1.2] )
or Text.Contains( [2], [1.3] )
then 1
else 0)
in
    #"Added Custom"

I have assumed Column 1 always has 3 values.  If not you will need to modify the OR conditions in the Custom Column called Match

Hope this provides you the guidance you were looking for.

Regards,