Attendance Formula Excel Sheet (with VLookup & IF Formula)

In this Attendance Excel file i have provided a formula that will track present employees from one sheet to another sheet, if the name is available then the formula will show “P” as present and if the name is not available in the list then it will be shown blank in the attendance sheet.

To make this sheet we have used Vlookup Excel Formula and IF Formula, you can download the file from below download button and the formula used is given here.



Tutorial Video

Download Excel File

Leave a Comment