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:
[TABLE="width: 313"]
<tbody>[TR]
[TD]"Rexona Men Deodorant Roll On Ice Cool 50ml"

and in the other sheet (Sheet B), I have value:
[TABLE="width: 717"]
<tbody>[TR]
[TD]"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 [TABLE="width: 313"]
<tbody>[TR]
[TD]"Rexona Men Deodorant Roll On Ice Cool 50ml"[/TD]
[/TR]
</tbody>[/TABLE]

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.


[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]