Please assist with an If formula referencing 2 cells

Melwayman Posts 1 Registration date Tuesday October 13, 2015 Status Member Last seen October 13, 2015 - Oct 13, 2015 at 06:30 AM
 Blocked Profile - Oct 16, 2015 at 05:18 PM
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 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 16, 2015 at 01:36 PM
i think if you provide example it would be easier to see what you seek
Blocked Profile
Oct 16, 2015 at 05:18 PM
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!