Fourmla if cells met criteria

[Novman]

If cell A3 is "text" and cell B3 contains the word "text" and cell D3 has any text return cell C3..

 

[Michael M]

someyhing like this ??

=IF(and(A3="car",B3="light blue",d3<>""),c3,"")

 

[Novman]

someyhing like this ??

=IF(and(A3="car",B3="light blue",d3<>""),c3,"")

Thank you for your reply.... but in cell B3 I only want to serch for "blue" like part text not the hole text

 

[Michael M]

Try

=IF(AND(A3="car",COUNTIF(B3,"*blue*"),D3<>""),C3,"")

 

[Peter_SSs]

Adjusting Michael's formula based on your image rather than your text, I think that you could actually be looking for this?

23 03 05.xlsm
	A	B	C	D	E
3	car	light blue	4	4	238
4	van	light blue	6
5	Car	white	2		7623
6	car	sky blue	5	5	4453
7	car	black	9		6521
8	car	white	1
9	car	bluebottle aqua	3	3	658
Novman

Cell Formulas
Range	Formula
D3:D9	D3	=IF(AND(A3="car",COUNTIF(B3,"*blue*"),E3<>""),C3,"")

Also, if you could possibly have something like row 9 and did not want to include that in the results because it does not contain the "word" "blue" then you could try this formula instead.

=IF(AND(A3="car",ISNUMBER(SEARCH(" blue "," "&B3&" ")),E3<>""),C3,"")

 

[Novman]

Thank you for your replys but either fourmlas use give me is not returning what I'm looking for, iv attached another photo to see it helps more.

 

[Michael M]

So rather than post screenshots, use the xl2bb to upload actual data that we can work with....see my tag for downloading.

 

[Novman]

So rather than post screenshots, use the xl2bb to upload actual data that we can work with....see my tag for downloading.

Iv tried downloading the xl2bb file, got it downloaded but when I try to open it I get mesage saying this file type is not supported in protected view, any ideas what I need to do

 

[Michael M]

Maybe this then

=IF(AND(A3="car",COUNTIF(B3,"*blue*")>0,E3<>""),"",C3)

 

[Peter_SSs]

Iv tried downloading the xl2bb file, got it downloaded but when I try to open it I get mesage saying this file type is not supported in protected view, any ideas what I need to do

Have you put it in a Trusted Location? See if this helps.