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

wsantos

Brass Contributor

Mar 06, 2020

MSTwork If your FY are fixed on those dates, you can use this (no need for the table):

="FY" &YEAR(I22)-2000+IF(MONTH(I22)>6,1,0)

OR copy column A over to D and use vlookup with partial match

=VLOOKUP(I22,B1:D3,3, TRUE)

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