I hope I can explain this one.
I need to be able to bring the next due date in the attached file. The problem i have is that the "unique" value is repeated and I need to bring it by Status, so my go to vlookup is not working. I tried doing a index match, but couldn't get it to work.
Example:
in the Process tab:
Job 1
step 1 status is complete.
Step 2 is started
I would need to bring step 2 date into the coming due tab.
The other problem, i would need it to stop at the first one that is not complete, see Job 2 for an example
Any help would be greatly appreciated.
I need to be able to bring the next due date in the attached file. The problem i have is that the "unique" value is repeated and I need to bring it by Status, so my go to vlookup is not working. I tried doing a index match, but couldn't get it to work.
Example:
in the Process tab:
Job 1
step 1 status is complete.
Step 2 is started
I would need to bring step 2 date into the coming due tab.
The other problem, i would need it to stop at the first one that is not complete, see Job 2 for an example
Any help would be greatly appreciated.
