Thanks Per unfortunately this brings back yes to all rather than yes or no??
any other thoughts
--
Thanks

Lise


"Per Jessen" wrote:

Hi Lise

Try this formula in C1 and copy it down as required:

=IF(ISERROR(MATCH(A1,$B$1:$B$1000;0)),"No","Yes")

Regards,
Per

On 31 Jul., 04:55, Lise wrote:
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