I want to write a formula that tells me which contract month the cell falls in based on an array look up of start and end dates.
My source data is a reference table with three columns. One for contract month, one for start date, and one for end date.
Input: Date
Output: Contract Month
G2=9/16/2016
A:A=Contract Month 1, 2, 3, 4....12
B:B=Start Date
C:C= End Date
Example: =IF(AND(G2>=INDEX(A:A(MATCH(G2, B:B, 0), G2<=INDEX(A:A(MATCH(G2, C:C, 0)
Bookmarks