Previous Topic Next Topic

If cell contains this text then....

Closed
Nate - Oct 25, 2016 at 04:26 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 26, 2016 at 01:58 PM
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 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Oct 26, 2016 at 01:58 PM
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

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Counting cells containing only numbers
jutulu -
jutulu -

4 responses