Finding partial match in a range

[miucus]

Hey everyone,

I have a list of SKUs in column A, that partially matches column D. I want a formula in column B to show what Style# the Sku belongs to. I need help writing this formula!

Thanks everyone for your help!


partial match.JPG

[Bo_Ry]

If the Style alway after "-"

Please try B2
=MID(A2,FIND("-",A2)+1,9)

If not,

=INDEX(D:D,SUMPRODUCT(ISNUMBER(FIND($D$2:$D$5,A2))*ROW($D$2:$D$5)))