Forum Discussion

pragnya_adi's avatar
pragnya_adi
Copper Contributor
Apr 16, 2024

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. ...
excel
HansVogelaar's avatar
HansVogelaar
MVP
Apr 16, 2024

pragnya_adi 

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.

  • pragnya_adi's avatar
    pragnya_adi
    Copper Contributor
    Apr 16, 2024
    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.
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Apr 16, 2024

      pragnya_adi 

      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.

       

      • pragnya_adi's avatar
        pragnya_adi
        Copper Contributor
        Apr 17, 2024

        HansVogelaar 

         

        Please find the google drive link for the excel that I have prepared till now.

         

        https://docs.google.com/spreadsheets/d/1a5KFtjJlau_kINytC7Uzg63Aw43gSBvW/edit?usp=drive_link&ouid=111019560275369372356&rtpof=true&sd=true

         

Resources