Look up from a list basic hlep please

[Trainer_J]

Hi, my first post and I need help.

In Colum A I have a full list of names of our employees
In Colum C I have names of who has attended a course.
In Colum B I want the formula to check the attendance against the full list and come back and say Yes Or No
can you help?

[Olly]

Try:

=IF(COUNTIF($C:$C,$A1),"YES","NO")

[Tony Valko]

Here's another one...

Data Range

	A	B	C
1	Name1	No	Name2
2	Name2	Yes	Name3
3	Name3	Yes	Name6
4	Name4	No	Name9
5	Name5	No	Name10
6	Name6	Yes
7	Name7	No
8	Name8	No
9	Name9	Yes
10	Name10	Yes
11	------	------	------

This formula entered in B1 and copied down:

=IF(ISNUMBER(MATCH(A1,C$1:C$5,0)),"Yes","No")

This version is very fast to calculate.

[AlKey]

and here is another one

=IF(ISNA(MATCH(A1,C$1:C$5,0)),"No","Yes")