partial match string in excel with unordered lookup value

[adnandmth]

Hi Guys,

Im wondering if I could lookup partial match based on below case;

let say I have value in column A row #1 in sheet A:

"Rexona Men Deodorant Roll On Ice Cool 50ml" and in the other sheet (Sheet B), I have value: "Rexona Ice Cool Roll On 50ml" What I need is to lookup several strings in that sheet B (Rexona + Ice + Cool + Roll + On) value to find the match value from Sheet A and return the value from sheet A which is "Rexona Men Deodorant Roll On Ice Cool 50ml" <tbody> </tbody> is there something I can do to solve this? and btw, this is my first time using this forum, apology if I my english or my explanation is not clear. <tbody> </tbody>

<tbody>
</tbody>