Find if items in array A is in Array B

Kinda like:::
Array A:
Jim
Bill
George
Dan
Ron
Scott
Randy

Array B:
Bill
Bob
Dennis

Tell me what items in array B are in array A.
Just True / False would work. I'd even take row numbers..

Should be simple.. I'm an old hat at Excel. But ...

If Array A is in column A, and Array B is in column B, in C1, use:

=MATCH(B1,$A$1:$A$7,0)

This will return the row number. If you want TRUE/FALSE, you can use:

=ISNUMBER(MATCH(B1,$A$1:$A$7,0))

HTH

Jason