If cell contains this text then.... [Closed]

Report
-
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
-
Hello,

Basically I'm looking for a formula that would let me do something like this: If cell d1 contains ANY part of Apple (ie apple pie, apple cake, whatever) then cell e1 would fill with the word apple. However if cell d1 contain ANY part of "peach" it would copy peach in cell e1 basically. Multiple causes for multiple results. In excel 2010.

Thank You

1 reply

Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
Nate, Good afternoon.

Suppose you list of words is at W5:W15

Try to use:

E1 -->
=LOOKUP(2^15, FIND(W$5:W$15, D1), $W$5:$W$15)

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!