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

Excel if cell contains text
If cell contains date then return value ✓ - Office Software Forum
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
Excel date format dd.mm.yyyy - Guide
Excel: If Date =, then enter a value ✓ - Excel Forum
Excel "IF" function w/ date in test cell ✓ - Excel Forum

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

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Counting cells containing only numbers

Excel - IF function with multiple words

If a cell contains any text then add a value

Similar discussions

Subscribe To Our Newsletter!