hi excelers,
I simply need help to find a repeated word across two arrays i.e:

A1
Boy
Cat
Dog

B1
Dog

C1
= 1

(if others words are find it should = 2)

the solution should be a simple one, hope its explained clearly for you... thanks for any further help.