Matching or vlookup?

[morz68]

Hi,
I have 2 sheets, one with people registered (email addresses) and the other with the ones that attended the seminar. For example, msmith@gmail.com appears in sheet 1 on row 300, and on sheet 2 on msmith@gmail.com appears on row 450. I want a yes or no, to see who registered actually attended. Any ideas? Thanks.

 

[AhoyNC]

You could use MATCH:

Book1
	A	B
1	Reg.	Y/N
2	Name2	No
3	Name1	Yes
4	Name6	Yes
5	Name10	No
6	msmith@gmail.com	Yes
Sheet2

Cell Formulas
Range	Formula
B2:B6	B2	=IF(ISNUMBER(MATCH(A2,Sheet1!$A$2:$A$5,0)),"Yes","No")

Book1
	A
1	Attended
2	Name1
3	msmith@gmail.com
4	Name4@gmail
5	Name6
Sheet1