Forum Discussion
JeffMAC1971
Dec 14, 2022Copper Contributor
Formula to evaluate a date between ranges and return a value in an array
I am trying to create a spreadsheet that has a Master Page that I can flip between Months. I've got my Drop down list figured out and I'm close (I think) on the formula, but I need some asssitance. I...
OliverScheurich
Dec 14, 2022Gold Contributor
=INDEX('Bills Amount & Due Date'!$B$3:$B$15,MATCH(1,(C3<='Bills Amount & Due Date'!$B$3:$B$15)*(Tabelle10!C4>='Bills Amount & Due Date'!$B$3:$B$15),0))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.
Bills Amount & Due Date:
Other Sheet: