Please assist with an If formula referencing 2 cells

Closed
Report
Posts
1
Registration date
Tuesday October 13, 2015
Status
Member
Last seen
October 13, 2015
-
 Blocked Profile -
Good evening,

I was hoping if someone could please assist with in creating an if statement to utilise in a training register. I have a dropdown menu - annually, monthly, when required in cell C3 in the subsequent column D3 is the date. I would please appreciate some help in creating a If statement that would reference the above dropdown menus and date to populate overdue, upcoming or when required. Thank you in advance Mel

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
i think if you provide example it would be easier to see what you seek
0

Please understand, the drop downs reference indices, not values. So if you have three items in the list, it will return either 0,1 or 2. Let us know if you are building the index from static items, or items from a RANGE!
0