Search If on text string

[bob]

B2 through B6 contain a string consisting of last names:

B2 - Jamison, Gooden, Blatche, Foye, Miller
B3 - Butler, Jamison, Blatche, Foye, Miller
B4 - Butler, Jamison, Haywood, Foye, Miller
B5 - Butler, Jamison, Haywood, Foye, Miller
B6 - Jamison, Gooden, Haywood, Foye, Miller

In column G, I want to place a formula that returns a 1 if "Gooden" is one
of names listed in column B or a zero if "Gooden" is not listed. Can anyone
help?

Thanks,
Bob

 

[Eva]

=if(iserror(search("Gooden",b2,1))=true,0,1)
Click yes if helped

 

[Teethless mama]

=SUMPRODUCT(--ISNUMBER(SEARCH("Gooden",B2:B6)))

 

[T. Valko]

One way...

=COUNTIF(B2,"*Gooden*")

Copy down as needed