A_SIRATIron ContributorAug 16, 2022SolvedFormula to Fetch data between two dates Hi , Please help with a formula as explained in the attached sheet. I am using office 2019. thank you ! Lookup Data between Dates..xlsx11 KBHarun24HRAug 16, 2022A_SIRAT For Excel-2019 you can try below formula- =IFERROR(INDEX($A$3:$D$15,AGGREGATE(15,6,(ROW($A$3:$A$15)-ROW($A$2))/(($A$3:$A$15>=$L$1)*($A$3:$A$15<=$L$2)),ROW(1:1)),COLUMN(A$1)),"") Lookup Data between Dates..xlsx12 KB
Harun24HRAug 16, 2022A_SIRAT For Excel-2019 you can try below formula- =IFERROR(INDEX($A$3:$D$15,AGGREGATE(15,6,(ROW($A$3:$A$15)-ROW($A$2))/(($A$3:$A$15>=$L$1)*($A$3:$A$15<=$L$2)),ROW(1:1)),COLUMN(A$1)),"") Lookup Data between Dates..xlsx12 KB
Harun24HRAug 16, 2022A_SIRAT For Excel-2019 you can try below formula- =IFERROR(INDEX($A$3:$D$15,AGGREGATE(15,6,(ROW($A$3:$A$15)-ROW($A$2))/(($A$3:$A$15>=$L$1)*($A$3:$A$15<=$L$2)),ROW(1:1)),COLUMN(A$1)),"") Lookup Data between Dates..xlsx12 KB
Harun24HRBronze ContributorAug 16, 2022A_SIRAT For Excel-2019 you can try below formula- =IFERROR(INDEX($A$3:$D$15,AGGREGATE(15,6,(ROW($A$3:$A$15)-ROW($A$2))/(($A$3:$A$15>=$L$1)*($A$3:$A$15<=$L$2)),ROW(1:1)),COLUMN(A$1)),"") Lookup Data between Dates..xlsx12 KB
