I am hoping to to get some help with a formula that would look for a partial match in one column when compared with another, returning the contents of a different column in the same row.
Column 1 name: Current Process stage
Column 2 name: Current process Stage status
Column 3 name: S1 Conduct Deep Dive Status
Current Process Stage a row will contain a name that matches the first two characters of the first two characters of S1 Conduct Deep Dive Status. In this example, a row in Current Process Stage contains "S1 Conduct Deep Dive". I trying to get a partial match on "S1" using the contents of a row in Current Process Stage and the column name "S1 Conduct Deep Dive Status", copying the contents of the row from S1 Conduct Deep Dive Status into same row of Current Process Stage status.
Before formula:
Current Process Stage Current Process Stage Status S1 Conduct Deep Dive Status
S1 Conduct Deep Dive Completed
S1 Conduct Deep Dive In Process
After Formula:
Current Process Stage Current Process Stage Status S1 Conduct Deep Dive Status
S1 Conduct Deep Dive Completed Completed
S1 Conduct Deep Dive In process In Process
I'm guessing that this needs a combo of Index and Match, but when I have run that it seems that the system wants to match the entire contents, not just the first few characters of the name or contents.
