Hi all,

I'm new here but hope to become a contributing member over time! I also hope I am not out of line with posting my question to a problem I have encountered.

Goal: to determine if a word matches exactly in an array of words.

Description: I have a list of words that I am trying to see if they are present in particular cells

List of words (contained in a separate work sheet called Keyword Types:
who
what
when
where
why
how
can
is
?

Cell phrases:
how do I calculate the chi square test?
when will I get my marks back?
regression line
understanding the p-value
thesis of mathematical significance


Here is the function I've come up with:

{=IF(SUM(NOT(ISERROR(FIND('Keyword Types'!$A$2:$A$2,$A2)))*1)>0,G$1,"Non-"&LOWER(G$1))}
Now, my code does work as expected, too well is the problem because when I copy the code for each cell it will match the word "is" to the cell phrase "thesis of mathematical significance" since the phrase contains the word "is" but that's not what I am trying to do obviously.

Does anyone have some insight on how I may be able to revamp my function to match whole words only?

Thank you!!

Regards