CODEWITHSUNDEEP
exceldatabasevbafunction
Chris Cole
Chris Cole

Reputation: 1

If cell string contains word from list in column, return value to new cell

First StackOverflow question :)

Within Excel, I have a list of all of my products (some 6000 odd). What I am wanting to do is:

Based on the description of the product (shown in Column C), if this cell contains ANY of the listed brands in Column D. Then Column E needs to fill the brand associated with the cell in Column C (Item description).

Please the example as shown

Example

Upvotes: 0

Views: 1218

Answers (1)

basic
basic

Reputation: 11968

You can use following array formula:

=INDEX($D$2:$D$7,MATCH(TRUE,ISNUMBER(N(IF(1,(SEARCH($D$2:$D$7,C2))))),0))

Array formula after editing is confirmed by pressing ctrl + shift + enter

enter image description here

Upvotes: 1

Related Questions