Vlookup with cells contains a specifc word

[shahdelsol]

I am using this formula and it is working fine but the only problem is the cell must contains the exact word and nothing else. How do I change it to where if vlookup finds the specific word in this example "apple" in column 12 would return true or false. Let's say if the cell value "apple is red" that's true or if the cells value is "apple/orange/245", that is also true. Right now the formula returns true if cells has only "apple" in it and nothing else.

=IF((VLOOKUP($O$3,INDIRECT("'"&INDEX($V$1:$V$30,MATCH(TRUE,COUNTIF(INDIRECT("'"&$V$1:$V$30&"'!$A$2:A150"),$O$3)>0,0))&"'!$A$2:P150"),12,0))= "apple", TRUE, FALSE )

 

[Aladin Akyurek]

Control+shift+enter...

=ISNUMBER(SEARCH("apple",VLOOKUP($O$3,INDIRECT("'"&INDEX($V$1:$V$30,MATCH(TRUE,COUNTIF(INDIRECT("'"&$V$1:$V$30&"'!$A$2:A150"),$O$3)>0,0))&"'!$A$2:P150"),12,0)))

 

[shahdelsol]

Thank you so much. I did work! I tried something like that but I must have typed something wrong.

 

[Aladin Akyurek]

Thank you so much. I did work! I tried something like that but I must have typed something wrong.

Glad to help.