Forum Discussion

Copper Contributor

Mar 19, 2019

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...

excel

Formulas and Functions

RyleeEman

Copper Contributor

Mar 23, 2019

RyleeEman

For those who are also making attendance record using Excel and barcode scanning for signing in and signing out, attached is my file of all formulas used for "For Barcode Scanning" sheet (data being inputted) and "Attendance Sheet" sheet (data being organized)

2019 Live Class Barcode Attendance Excel Formulas.docx14 KB