Same Formula, Same Input, Different Results - VLOOKUP with nested IF referencing two columns

I use excel in conjunction with a barcode scanner to create attendance sheets that have sign in / sign out data for live classes. In my excel file, I work with two sheets: Attendee Information and Si...