Code:
=IF(ISERROR(LOOKUP(2^15,SEARCH(brands,A1),brands)),0,LOOKUP(2^15,SEARCH(brands,A1),brands))
i would like the formula to consider the space between words
the above formula looks on a cell A1 against a list of words to see if the cell A1 matches a word from the list of brands. if the match if found then it will output that match from brands
issue here is that it matches words that it shouldn't. see below an example
columnA, brands, output - header
adidas group of word1 , adidas, adidas - the result is good
adidasBaskets group of word1 , adidas, adidas - the result is NOT good
adidas Baskets group of word1 , adidas, adidas - the result is good
NOT good is for adidasBaskets
good is for adidas Baskets
so the correction should be for the NOT good.
i'd appreciate a fix for this formula as there are words that trigger a match even tho it's not the case for it.
i would like the formula to consider the space between words
Last edited: