jl2509
Board Regular
- Joined
- Oct 30, 2015
- Messages
- 198
- Office Version
- 365
- Platform
- Windows
Hi all
I wonder if someone can help me out here.
I am looking to find the "Next Phase Due Date" from the data in B3:H5
The next Phase Due Date to be shown in Cell C11 should be 25/11/23 as this is next phase baseline date where the phase has not yet been completed as indicated by "N/C"
I would also like to show the next phase due in Cell C9, and in this case it would be "Phase 4"
I am not sure how to lookup across the dates and return the values required.
Any help is much appreciated
I wonder if someone can help me out here.
I am looking to find the "Next Phase Due Date" from the data in B3:H5
The next Phase Due Date to be shown in Cell C11 should be 25/11/23 as this is next phase baseline date where the phase has not yet been completed as indicated by "N/C"
I would also like to show the next phase due in Cell C9, and in this case it would be "Phase 4"
I am not sure how to lookup across the dates and return the values required.
Any help is much appreciated