Lookup Matching Word Within A Sentence

[zakmuh]

Hi All,

I need help with a formula please. I want find the matching word within a sentence (within one cell).

For example:

From Column A (A4:A7) 'Ninja Electric Hob', I want to lookup the exact matching word (not partial match) 'Ninja' from Column C (C4:C7) and return the exact matching Title in Column E.

I've attached a screenshot from Excel.

Thanks

Zak

 

[Fluff]

I said it can't be done in Xl.

 

[zakmuh]

Apologies....in excitement I didn't read it properly lol

Would that be a different software then

 

[Fluff]

No Xl is just shorthand for Excel.

 

[zakmuh]

I know. You said it can't be done in XL, so I asked if it can be done with any other platform or software

 

[Fluff]

I have no idea, but I doubt it.

 

[zakmuh]

I have no idea, but I doubt it.

Okay, thanks

 

[Fluff]

My pleasure.