Hi pmeltzers. Welcome to the forum.
Try this.
With a lookup table (column D here) array enter this formula in B2 and fill down.
If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
|
A |
B |
C |
D |
1 |
Input |
Output |
|
Valid to cancel |
2 |
12/31 valid to cancel *psm 10/31 valid to reschedule in | Valid to Cancel |
Valid to cancel |
|
Valid to Reschedule out |
3 |
12/31 valid to reschedule in *psm 10/31 valid to reschedule out | Valid to Reschedule in |
Valid to Reschedule In |
|
Valid to Reschedule In |
4 |
12/31 valid to *psm 10/31 valid to reschedule in 11/01 unable to cancel | Valid to Reschedule in |
Valid to Reschedule In |
|
|
5 |
12/31 valid to Reschedule out *psm 10/31 valid to reschedule in | Valid to Reschedule out |
Valid to Reschedule out |
|
|
Bookmarks