Forum Discussion
Date/Data referencing
I am building a spreadsheet for work. My first sheet is an overview and my second sheet is my user input data. The idea is for me to input data everyday into the sheet (each day has a different row) ...
Hello jdauzat,
You can make your Overview sheet automatically pull data for any date using XLOOKUP (Excel 365/2021) or INDEX/MATCH (all versions).
Assume your input sheet is named InputData, column A has dates, columns B, C, D… have data, and cell B1 on Overview has the date to look up.
For XLOOKUP use: =XLOOKUP(B1, InputData!A:A, InputData!B:D, "Not Found").
For INDEX/MATCH use: =INDEX(InputData!B:Z, MATCH($B$1, InputData!A:A, 0), COLUMN()-COLUMN($B$2)+1) and drag horizontally for multiple columns.
Changing the date in B1 will automatically update all referenced data. This works for daily dashboards where each row in InputData is a different date.