So I want C2 for example return one of four things depending on what is in D2 and E2.
If both D2 and E2 contain "Current" then I want C2 to say yes.
if either D2 or E2 contain "Due soon" I need C2 to say "Due soon"
If either D2 or E2 say Expired then I need C2 to say expired
If both D2and E2...
I have a if formula based on 2 cells:
D15 = YES and D17 = BLANK Then return "C2"
IF D4 = YES and D18 = BLANK then return "C2"
If Both D15 and D4 = YES and both D17 and D17 = blank then return "C2"
Repeat cell reference until blank cell is reached then skip one cell down and use new cell reference. Using formula not VBA
I have a list that looks like this.
Column A Column B