Complicated formula or look-up table help
This is kind of embarrassing, but I thought I had this worked out with lots of assistance in another excel forum. Since then, some things changed and the now it’s not working and I almost have to start from scratch. Here’s the problem: I have students in 3 separate groups and each group has different ‘follow-up’ requirements based on their ‘assignment month’ and everything has to be tied to the current date such that it’s easy to identify what each students next follow-up month is (based on their group). The whole thing looks like it should be doable w/ some formula, but that’s well beyond my skill set. I’ve attached the sheet with a couple of expected results and welcome any questions. Thanks.
|