I would like cell O4 (Due Date) which includes a formula to check whether a cell A4 (Client List) is either blank (then O4 stays blank), or if it is a certain client or not. If A4 is a certain client then it chooses a date on another sheet, if not, then it chooses another date. I would like for O4 to also check to see if cell R4 (Report Submission Date) has a date in it, if R4 does have a date input, then I want O4 to change to a different set of reference dates.
Example
O4: if A4 is blank then O4 is blank, if A4 is client 1 then choose sheet 2 cell C3, if it is not client 1 then choose sheet 2 cell C5, if A4 is client 1 and R4 is not blank then choose sheet 2 cell E20, if A4 is not client 1 and R4 is not blank choose sheet 2 cell E21.
