Apr 04 2023 04:36 PM
=XLOOKUP($D$2,Sheet1!$D2:$D$1000,Sheet1!$A2:$A$1000,"",0,1)
I have 7 tabs (days of the week) that pull information off one sheet (all the information that needs to be sorted). I can get it to pull the information based off the dates matching with the above formula. The sheet it pulls from the dates move around and sometimes there is more or less of said date. 4/3 is the first date, and it only pulls the necessary information. 4/4 starts on row 4 from the data sheet, it is bringing the same data over 3 rows above and the row it starts. How do I make it bring the data over only one time and skip the other rows? The number of times the date is used changes weekly, like sometimes Tuesday will have 5 and other times 10.
Apr 04 2023 04:52 PM
Apr 04 2023 08:10 PM