Reverse Partial Match

I have item description and need to find supplier name with partially keyword as below exam (lookup value is column4 and lookup array is column2 , return result is column1 place on latest column) ...