Help matching/looking up cells from another worksheet

[BYates123]

I have one worksheet ("Sheet 1") with a list of names in column A, and another worksheet ("Sheet 2") with a list of names in column A and a list of years respective to the date they have participated in an event, either 2012 or 2013. In Sheet 1, I need one column to check if that person was in an event in 2012, and another column to check if they were in an event in 2013. "Yes" if they were in the event that year, "No" if they were not. It gets kinda tricky because most people were in multiple events each year, so they may have 5 dates respective to their name, both in 2012 and 2013. I've tried various vlookup, index, and match combinations but none seem to work. Help?

 

[venkat1926]

SEE SHEET1

Excel Workbook
	A	B	C
1	NAME	IN 2012	IN 2013
2	G	N0	N0
3	A	YES	NO
4	S	NO	YES
5	D	N0	N0
6	F	YES	NO
Sheet1

SEE SHEeT2 BASIC DATA

Excel Workbook
	A	B
1	NAME	YEAR
2	A	2012
3	S	2013
4	F	2012
5	J	2013
6	L	2011
7	T	2012
Sheet2

see formula in B2 in sheet1
copy this formula both down and across one column.