Searching Excel for a value

S

Spottie

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?
 
D

Dave Peterson

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

is one.
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?
Click to expand...
 
Top