=isnumber(match(b1,a:a,0))

is one.

Spottie wrote:

If column A and column B both contain a list of names, what formula con I put
in C1 so the result indicates if B1 exists anywhere in column A?

--

Dave Peterson