If cell contains certain text dont return vaule of other cell

[Novman]

Using this fourmla I get what I'm looking for..
=if(isnumber(search("light blue",C3)),D3)*isnumber(search(B3,"CAR")) I get the value of yellow cars from cell D3
What I can't get is, if cell C3 has part text as the word "blue" and B3 "CAR" then DONT return value of cell D3
Basically if cell C3 has word blue then DONT return value of cellD3.

 

[Fluff]

It's best if you start a new thread.