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.
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.