How do I search for a character in column 1 and display another character in column 2

**anon** · 12-23-2010, 11:44 PM

How do I search for a character in column 1 and display another character in column 2?

For example, let's say the cells in column 1 have these entries...
A1: blue, green, red
A2: red, yellow green,
A3: this is cool
A4: green eyes
A5: blue skies
etc...

I want a formula in column 2 that is something along these lines:
If cell A1 contains 'blue' then display 'awesome'

Thanks

**NBVC** · 12-24-2010, 12:08 AM

Try:

=IF(Isnumber(search("blue",A1)),"awesome","")

**anon** · 12-24-2010, 12:14 AM

thanks so much!

**anon** · 01-20-2011, 11:47 PM

ok, new question.

using the same example, how do i do something like this:

if A1 has 'blue' display 'awesome', if A1 has 'green' display 'sweet', if A1 has 'blue' and 'green' display fantastic

all in one cell?

**NBVC** · 01-21-2011, 08:44 AM

Try:

Please Login or Register  to view this content.

How do I search for a character in column 1 and display another character in column 2

LinkBack

Thread Tools

Rate This Thread

Display

How do I search for a character in column 1 and display another character in column 2

Re: How do I search for a character in column 1 and display another character in colu

Re: How do I search for a character in column 1 and display another character in colu

Re: How do I search for a character in column 1 and display another character in colu

Re: How do I search for a character in column 1 and display another character in colu

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions