My question
In the attached spreadsheet, I have highlighted an example that illustrates my problem. "Bow" windows are a type of window. However, keywords that contain the text string "bowie" (which is a city in maryland) are being labeled as "Bow".

How do I modify my formula to look up EXACT MATCH text strings only?

Keyword Labeling Formula.xlsx

I have this crazy formula that looks for values in a list of keywords. Where it finds a given value, it will label it by assigning the header label to the keyword. If no value is found, it calls the label "Uncategorized".

{=IFERROR(INDEX($E$1:$AG$1,MIN(IF(ISNUMBER(SEARCH(IF($E$2:$AG$100="","||",$E$2:$AG$100),A10)),COLUMN($E$1:$AG$1)-COLUMN($E$1)+1,COUNTA($E$1:$AG$1)+1))),"Uncategorized")}
I did not come up with this awesome formula, user NBVC did here:
http://www.excelforum.com/excel-form...57#post2914657