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.
Formula:
=IF(E2=IFERROR(VLOOKUP(E2,Present!D:D,1,0),""),"P","")- If you want to calculate the age of employees then you should check this tool which calculates Age just in 1 second.
Tutorial Video