Hi

I have two columns one has names automated from another worksheet and one
has other names entered manually (the two columns show two attendences)
example
Column A = town Column B = Country
jack black Sue Smith
snow white Jack Black

using A1 as an example I want a formula to check if the name in A1 is in
B1:b2000 and if it is type yes and if not no

Any help as always appreciated
--
Thanks

Lise