PDA

View Full Version : I need some help with Excel



jayploc
09-08-2008, 09:53 AM
Hi, sorry if this is posted in the wrong section...

I have a workbook with 2 sheets:

SHEET1 is a roster of people (with their ID numbers) who attended a seminar at the beginning of the semester.

SHEET2 is a roster in the same format but containing all people who attended tutoring sessions throughout the semester.


What I want to do is make a "1" for all the people in sheet1 under the column "SI_Y" who appear on the second list, and a "0" if they dont. (Out of the people who attended the seminar, who went to tutoring).


I put:
=--(NOT(ISNA(MATCH(--A2,Sheet2!A:A,0))))
in O2 in sheet1 (and copied down the entire column), but this didn't work.


If anyone has a solution, that would be awesome.

Thanks,
Jay P.

Bob Phillips
09-08-2008, 10:20 AM
=--ISNUMBER(MATCH(A2,Sheet2!$A$2:$A$3113,0))

jayploc
09-08-2008, 10:46 AM
You are awesome, thanks a lot.