Formula for returning value based on whether a date is between two dates
I have a main sheet and a reference sheet. On the main sheet there is a Fiscal Quarter which is based on a Program Date column. HOwever, I want to add a formula that refers to a reference sheet whereby I have two dates. If the Program date falls within the Start Date and End Date of a quarter, I want the formula to return the value from the Primary Column see below.
I thought Index Collect with two criterion would be best but I can't get it to work. Thoughts?
Help Article Resources
Check out the Formula Handbook template!