Excel keyword exact match from list of keywords in dataset

0
votes

I am struggling to create a formula on matching the exact list of keywords to a dataset. I have tried many formulas but seems like nothing is working. So my requirement is to detect keywords from the list of keywords mentioned in col R and data set is present from column B to Colmn N. If suppose there are two keywords found in row 2 then it will give me True value and name of those two keywords that are found. Also if keyword is BAT and in data set we have something like BATMAN then it should not detect Batman for keyword BAT.

Formula i tried =IFERROR(INDEX($R$2:$R$5,MATCH(TRUE,SEARCH($R$2:$R$5,B2)>0,0)),"Not found")

enter image description here

excelexcel-formulaexcel-2010excel-2007export-to-excel
Check on here, there are several similar q&a. – Solar Mike
I have tried searching alot of them, but noe of them were able to solve this BAT and BATMAN match issue. Formula mentioned will match batman also for a keyword BAT – Navneet Singh
What is your exact excel version? You tagged both 2007 & 2010. – Harun24hr
So do one search for "BAT" and another for "BATMAN" then subtract. – Solar Mike
Can you share sample data of examples of expected good results and sample of data of wrong results? – P.b