Sheet1 contains a table with two columns: Names, Y/N. Names contains a list of all the possible people who may have completed a survey. Y/N should indicate whether or not they have completed the survey.

Sheet2 contains only one column of values: Completed. Completed is a list generated with names of everyone who has actually completed the survey.

I require a function/formula that will place a "Y" next to the names of those that have completed the survey (names that appear on Sheet2), and a "N" next to the values that do not appear on sheet2.

Basically, Sheet1 should return Y/N values as such:

Name Y/N
Jack Y
Jim N
Jeff Y
James Y



If Sheet2 looks like this:

Completed:
James
Jack
Jeff

Is this possible? Any help is appreciated! Also if there is another way to do this, it would be great to know! Basically I receive a list of people that have completed the survey, and there are about 150 people who are required to take it. The table should represent which people have taken the survey, and which have not.

Thanks