I have made a formula that basically looks for a string of text inside a cell and if it finds it puts it in another cell. I needed to check three cells so I did three separate formulas (because I'm useless at embedding the formulas).
So now I have three cells with the information in them. All of the information is the same. It's basically if you find the word diamond write diamond. So now in my three columns some are empty and some have the word diamond (or another gem). I need to find a way to make a final column which takes all three columns and if not blank puts the answer in the final column.
It is something along the lines of:
A1 is something like "I like diamonds"
B1 is "category: diamonds from the far east"
C1 is something like "diamonds from the far east are wonderful"
I've got three formulas (D1, E1, F1) which search for the string in A1, B1, C1 individually, and return the string if they find it. That part works.
Now I want G1 to search D1, E1, F1 and if they're not blank then return the string. My IF statement works, but if the final column is blank it returns blank. That's why I tried to do an OR statement combined with IF.
I tried to do this
It doesn't work though. I think I need an OR statement. So I tried to make one:
But that didn't work either. Can anyone more intelligent than I help me out?