Forum

Notifications
Clear all

Lookup Matching Word withing A Sentece

4 Posts
2 Users
0 Reactions
97 Views
(@zakmuh)
Posts: 3
Active Member
Topic starter
 

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

1.JPG

Thanks in advance

Zak

 
Posted : 17/03/2021 8:52 am
(@zakmuh)
Posts: 3
Active Member
Topic starter
 

The best I could do was this one and that's based on 'partial match'

=unique(if(isblank(A4:A7),"",(IFERROR(VLOOKUP("*"&C4&"*",$A$4:$A7,1,FALSE),"")))) - used the formula for each cell

Issue here is, for vero keyword 'shark', it returns 'Baby play mat Sharkins' and pics the first one on the list

Ninja Electric Hob
Myninja Colouring Book
Baby play mat Sharkins
Shark Vacuum Cleaner
 
Posted : 17/03/2021 10:46 am
(@purfleet)
Posts: 412
Reputable Member
 

Please upload a workbook example instead of pictures so we dont have to waste time recreating the data that is already to hand

 
Posted : 17/03/2021 4:04 pm
(@zakmuh)
Posts: 3
Active Member
Topic starter
 

Found the formula through another forum:

=ARRAYFORMULA(IFERROR(LOOKUP(2,1/SEARCH(" "&C4&" "," "&A$4:A$7&" "),A$4:A$7),""))

Cheers

 
Posted : 18/03/2021 12:26 pm
Share: