Attendance list

  • Thread starter Thread starter john.menken
  • Start date Start date
J

john.menken

I have two spreadsheets in the same workbook.
Spreadsheet 1 has a list of Last and First names for everyone in
Division A.
Spreadsheet 2 has a list of everyone that attended training from
across multiple divisions.

I need to add a couple of columns in spreadsheet 1 entitled Attended
and Not Attended then somehow put a check in the correct column based
on whether or not that person attended the training. At first I
thought vlookup was the way to go but I cannot get that to work. Does
anyone have an idea how I might go about this? I am using Excel 2003.
Thank you.
 
Try something like this:

Sheet2 names in column A

Sheet1:

Names in A2:An

B1 = column header = Attended
C1 = column header = Not Attended

Enter this formula in Sheet1 cell B2:

=IF(COUNTIF(Sheet2!A:A,A2),"X","")

Enter this formula in Sheet1 cell C2:

=IF(B2="X","","X")

Select both B2 and C2 then copy down as needed.
 
Back
Top