masseyhemenway
New Member
- Joined
- Jan 31, 2020
- Messages
- 3
- Office Version
- 2010
- Platform
- Windows
Hello,
I have a spreadsheet that tracks attendance for classes. What I am attempting to do is create a different spreadsheet that will serve as an absent report. The Main Spreadsheet has a column that lists an "X" for two or more absences so I was going to use that criteria for listing the student on the absent report. On the report will be the student name, class, teacher. I've tried using VLOOKUP but so far have not been able to get it to work. Any help would be greatly appreciated. Thanks.
I have a spreadsheet that tracks attendance for classes. What I am attempting to do is create a different spreadsheet that will serve as an absent report. The Main Spreadsheet has a column that lists an "X" for two or more absences so I was going to use that criteria for listing the student on the absent report. On the report will be the student name, class, teacher. I've tried using VLOOKUP but so far have not been able to get it to work. Any help would be greatly appreciated. Thanks.