Matching values instead of lookup value

[Anonymous]

Hey gurus 🙂

I have two table, one with SKUs 

and other table with the first few letters SKUs and description of SKUs

How can I match the full SKU to the one with the first few letters, in a new column to get the description

example:

Table 1 SKU: AZ-PPP-12 

Table 2 SKU: AZ-PPP  -> Hardware Part

How can table 1 read that AZ-PPP-12 is  hardware part?

Thanks a million

[amitchandak · Accepted solution]

@Anonymous , Create a new column in tables 1

maxx(filter(Table, containsstring(Table1[SKU], Table2[SKU]) ) , [SKU Desc] )