Forum Discussion
Excel Formula help, IFS function
I am trying to write an IFS statement to determine if a date falls within a certain date range. Date Range: is in Sheet 2 (see below) A B C 1 FY18 7/1/2017 6/30/2018 2 FY19 7/...
Perhaps
=INDEX(Sheet2!$A:$A,MATCH(1,INDEX(($I$22>=Sheet2!$B:$B)*($I$22<=Sheet2!$C:$C),0),0))My original formula is working, however it only returns the result "FY18" even if the date falls in one of the other fiscal years.
SergeiBaklan no luck 😞
