Search If on text string

B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top