how to search for a spesific word with in a cell and display in the next cell (HELP!!!!)

Good morning all,

I have a list of cells that contain words and colors (e.g Vivid fancy yellow), i would like to have the next cell contain just the color (e.g yellow).... after some searching on Google i came up with this code: =IF(SEARCH("Yellow",T17),"Yellow"), that works great for the ones that are yellow however when i try to add the next color as follows: =IF(SEARCH("Yellow",T17),"Yellow",IF(SEARCH("Orange",T17),"Orange"))(i need to do it for about 6 or 7 colors).

Please Advise on what i am doing wrong.

Joseph

Thanks!!!

IT WORKED!!!!!!!

Part two of this question that i just realized that i didnt put in....
=IF(U3=OR("Yellow","Orange","Blue","Green","Brown","Pink","Champagne"),U3,"None" (U3 is where i put the code that you helped me with in the last question) is returning me a value error any idea why ?

Thanks again!

I Tried it and the answer is coming up incorrect meaning in the column it says yellow but your formula is returning "NONE"

Any ideas ?

Ok i got it there was value that got input in the wrong place and it was throwing the whole thing off

Thanks to all that helped

Hey all i have come across an issue that just came up with this string if based on the formula "=IF(ISNA(LOOKUP(2^15,SEARCH($D$1:$D$2,T17),$D$1:$D$2)),"",LOOKUP(2^15,SEARCH($D$1:$D$2,T17),$D$1:$D$2))" (thanks again benishiryo)
the value in t17 is Yellow(Colored) what do i need to change so that it wont give me a zero. I have the color yellow in my "D:D" list.

Thanks !!!!

I solved it.