Hi all,
I have used the isnumber(search) function to check if some text is available in a specific cell. He searches in a cell with multiple words. And if the word is found, he gives TRUE.
The problem is: If a part of the specific text is found, he also gives True, and that is not what I want. i want to have a check if the EXACT word is found. There is the Exact function, but that can't be used because the cell that he needs to check for the specific text, contains multiple words.
Has someone the solution for this? Here you see screenshot. i have added the XLS file.
function-a.png
function-b.png
isnumber exact function.xlsx
Thanks!
Bookmarks