How can i use an IF statement to return the value of the adjacent cell in the PHASE column for a status cell that is IN-PROCESS. Or is there an easier way?
For any Status of IN-PROGRESS, i want to return the Adjacent same row Phase value.
From below something like:
If Status column = IN-PROGRESS then show Phase column adjacent (Firm SOW and Order draft)
