Second part is based on the row number of the returned cell value, match other two columns. Maybe an example will make this more clear:
From the raw data I want to extract the program name whenever there is no responsible person assigned (cell blank), After I want to be able to match the...