Forum Discussion

Copper Contributor

Mar 06, 2020

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/...

Formulas and Functions

MSTwork

Copper Contributor

Mar 06, 2020

wsantos

FY isn't fixed on those dates. The date could fall between those date ranges and if it does I want the true statement to be FY18, FY19, or FY20 depending on what date is in I22.

I don't think the Vlookup will work.

wsantos

Brass Contributor

Mar 06, 2020

vlookup is using a partial match. Just try it.

MSTwork