I have a list of student numbers in col A

A list of students who attended a lecture in B

how can I find out who is missing .

I tried a if along if b1:b100=a1,"y","n" so I would get a list y and n in the correct order but it looks like if wont accept ranges

Thanks

Mark