Hi folks
I have taken over a spreadsheet, the data is updated every day based on the date. The District sheet has data updated every day, when a new day arrives we unhide the sheet and put the data in. On the second data sheet I have used an xlookup to bring the information from district. What I am looking to do is bring in the data based on the date in N23. pulling from district sheet to the data sheet. Any help would be greatly appreciated.
I have taken over a spreadsheet, the data is updated every day based on the date. The District sheet has data updated every day, when a new day arrives we unhide the sheet and put the data in. On the second data sheet I have used an xlookup to bring the information from district. What I am looking to do is bring in the data based on the date in N23. pulling from district sheet to the data sheet. Any help would be greatly appreciated.
Book1 | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
2 | Total | North East | East | Total Area | East Gate | North Gate | South Gate | South District | Total | Under side | Over Side | Length Ways | Area | |||
3 | 4/3/22 | 89 | 98 | 75 | 71 | 87 | 532 | 532 | 67 | 65 | 0 | |||||
4 | 4/2/22 | 98 | 98 | 48 | 65 | 37 | 29 | 29 | 29 | 29 | 0 | |||||
5 | 4/1/22 | 87 | 43 | 39 | 32 | 46 | 10 | 10 | 8 | 198 | 0 | |||||
6 | 3/31/22 | 76 | 16 | 726 | 59 | 59 | 60 | 60 | 98 | 52 | 0 | |||||
7 | 3/30/22 | 124 | 976 | 54 | 1 | 87 | 78 | 78 | 3 | 78 | 0 | |||||
District |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A3 | A3 | =TODAY() |
A4 | A4 | =TODAY()-1 |
A5 | A5 | =TODAY()-2 |
A6 | A6 | =TODAY()-3 |
A7 | A7 | =TODAY()-4 |
Book1 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | L | M | N | |||
23 | 4/1/22 | 89 | 98 | 75 | 71 | 532 | 67 | 65 | 0 | 87 | 532 | 2/1/22 | |||
24 | 2/3/22 | ||||||||||||||
25 | 2/2/22 | ||||||||||||||
26 | 2/1/22 | ||||||||||||||
27 | 3/31/22 | ||||||||||||||
28 | 3/30/22 | ||||||||||||||
Sheet2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C23:L23 | C23 | =XLOOKUP(C22,District!$C2:$N2,District!$C3:$N3) |
Named Ranges | ||
---|---|---|
Name | Refers To | Cells |
total1 | =District!$C$3:$N$3 | C23:L23 |