I'm trying to search for an exact match of array of strings in each individual cell that contains long strings.
The strings could be comma delimited, which is considered acceptable, but I'm having trouble finding exact word match when a word contains the alphabets of another word. E.g. "Clamp" should not evaluate true when searching for "Lamp". Please advise how I can achieve this, below is what I have so far:
The strings could be comma delimited, which is considered acceptable, but I'm having trouble finding exact word match when a word contains the alphabets of another word. E.g. "Clamp" should not evaluate true when searching for "Lamp". Please advise how I can achieve this, below is what I have so far:
Book1.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | String | Evaluated State | Actual State | Keyword | ||
2 | Lamp | TRUE | TRUE | Lamp | ||
3 | Clamp | TRUE | FALSE | Right | ||
4 | aagsdg | FALSE | FALSE | Left | ||
5 | asdfs | FALSE | FALSE | |||
6 | Leftie | TRUE | FALSE | |||
7 | Left | TRUE | TRUE | |||
8 | Lamp, Bright | TRUE | TRUE | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2:B8 | B2 | =OR(ISNUMBER(SEARCH($D$2:$D$4,A2))) |
Press CTRL+SHIFT+ENTER to enter array formulas. |