Match a part of text

[salehaljoei]

hello guys
I have two tables
The first table contains column [code1], which contains a code, for example
ab-ss-pt
ab-ss-pt-l2
ab-ws-pr-l1
ab-ws-pr
The second table contains column [code2] containing code, for example
ab-ss-pt-l1-3526         =   ab-ss-pt
ab-ws-pr-l1-3566        =   ab-ws-pr-l1
ab-ss-pt-l1-7885         =   ab-ss-pt
ab-ss-pt                        =   ab-ss-pt
ab-ss-pt-l2                   =   ab-ss-pt-l2
ab-ss-pt-l1                   =   ab-ss-pt

What I want is to create a [matching] column in the second table that searches for the code in column [code2] with column [code1] in the first table, and get the code is closest.

thanx

[AleksiAlkio · Accepted solution]

Don't know your whole data in Table1, but with a virtual column the formula could be something like..
INDEX(SORT(SELECT(Table1[Code1],CONTAINS([_THISROW].[Code2],[Code1])),TRUE),1)

[salehaljoei]

Thank you very much, it worked successfully

[AleksiAlkio]

Good to hear!