Forum Discussion
Populate back values entered based on value of a specific cell
I'm creating this attendance tracker in excel. As you can see that there are entries like a, p for various dates for the month of Jan (B2 cell). These entries are done manually for each date. ...
You should have a separate sheet that lists the codes for the entire year. You can then use a VLOOKUP or XLOOKUP formula to display the codes on the sheet from your screenshot.
Microsoft has several attendance tracker templates that do this.
Hi Hans,
Thanks for the info.
Since I'm not much aware of it, so could be able to share some code for the VLOOKUP or XLOOKUP formula for this scenario.
And also if you could share links to few of the attendance tracker templates that would be achieving the scenario that I want to implement.
Thanks for the info.
Since I'm not much aware of it, so could be able to share some code for the VLOOKUP or XLOOKUP formula for this scenario.
And also if you could share links to few of the attendance tracker templates that would be achieving the scenario that I want to implement.
If you'd like help with your workbook, please attach a copy of it without sensitive information, or make it available on Google Drive, OneDrive, Dropbox or similar.
To find existing templates, select File > New in Excel.
Type attendance tracker or absence tracker in the search box, then press Enter.
Please find the google drive link for the excel that I have prepared till now.
When I click your link, I get an "Unauthorized" error.
