Search word in cell from imported list with name manager

[Gylle]

Hi all

Need help to simplfy this:

Right now im importing a workbook into aother workbook and im using this string to search for words that migh be in a cell:

‎=IF(C32="";""; IFERROR(INDEX(findApr1; MATCH(TRUN; ISNUMBER(SEARCH(FindApr; C32));0));" V"))‎

The name manager contains this:
FindApr:
=OFFSET(April!$A$1;1;0;COUNTA(April!$A:$A)-1;1)

FindApr1:
=OFFSET(April!$A$1;1;1;COUNTA(April!$A:$A)-1;1)

Now all this works just fine.

But i would like it to search just for the word and then return just yes or no

Yes i can just put yes or no in the coloum next to the word but there must be an easier way to and skip stright to yes or no.
So i search the first coulmn and return if the word is found.

When i try to modify this it only search the first cell in April sheet

And MATCH is not excat it still returns true even if the word has one or two extra letters to it
excampel: cucumber returns true and cucumbers also returns true.

 

[Gylle]

I fixed it with this:

formular string:
=IF(C9="";"";IF(MAX(IFERROR(SEARCH(FindApr;$C9);0);0)>0;"P";"V"))

name manager string:
=OFFSET(April!$A$1;1;0;OFFSET(TRUE;INDEX(ISBLANK(April!$A:$A);0;0);0)-2)

Works