Spreadsheet: 705288d1605990589-outputting-values-to-new-column-based-on-id-and-if-condition-sampx-1-
Sheet: Sheet1

ID: |  |  | Type |  |  |  |  | Delivery: | Relation: | Expected Value: |  | Current Formula | Expected Result
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/- |  |  | -
1130 |  |  | RRRT |  |  |  |  | RRR |  | -/-/-/-/- |  |  | -
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/- |  |  | -
1130 |  |  | RRRT |  |  |  |  | RRR |  | -/-/-/-/- |  |  | -
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/- |  |  | -
1130 |  |  | RRRT |  |  |  |  | RRR |  | -/-/-/-/- |  |  | -
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/- |  |  | -
1130 |  |  | RRRT |  |  |  |  | RRR |  | -/-/-/-/- |  |  | -
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/- |  |  | -
1130 |  |  | FFFT |  |  |  |  | RRR |  | -/-/-/-/- |  |  | -
11344 |  |  | AAAT |  |  |  |  | RRR | CCCR | TPAR |  |  | [NAME]
11344 |  |  | FFFT |  |  |  |  | ABC w/ I | [NAME] | TPAR |  |  | [NAME]
11454 |  |  | TTTT |  |  |  |  |  | CCCR | No Scenarios |  |  | No Secenarios
11454 |  |  | AAAT |  |  |  |  | AAA | CCCR | No Scenarios |  |  | No Secenarios
11454 |  |  | AAAT |  |  |  |  | AAA |  | No Scenarios |  |  | No Secenarios
11454 |  |  | AAAT |  |  |  |  | RRR |  | No Scenarios |  |  | No Secenarios
11556 |  |  | AAAT |  |  |  |  | AAA | CCCR | CCCR/ CCCR |  |  | CCCR/Mickey Mouse
11556 |  |  | IIIT |  |  |  |  | RRR | CCCR | CCCR/ CCCR |  |  | CCCR/Mickey Mouse
11556 |  |  | FFFT |  |  |  |  | ABC w/ I | [NAME] | CCCR/ CCCR |  |  | CCCR/Mickey Mouse
11556 |  |  | FFFT |  |  |  |  | ZZZ w/o I | IIIR | CCCR/ CCCR |  |  | CCCR/Mickey Mouse
11556 |  |  | AAAT |  |  |  |  | ZZZ w/o I | CCCR | CCCR/ CCCR |  |  | CCCR/Mickey Mouse
11556 |  |  | AAAT |  |  |  |  | AAA | CCCR | CCCR/ CCCR |  |  | CCCR/Mickey Mouse
11556 |  |  | IIIT |  |  |  |  | RRR | CCCR | CCCR/ CCCR |  |  | CCCR/Mickey Mouse
11556 |  |  | FFFT |  |  |  |  | ABC w/ I | CCCR | CCCR/ CCCR |  |  | CCCR/Mickey Mouse
11556 |  |  | FFFT |  |  |  |  | ZZZ w/o I | IIIR | CCCR/ CCCR |  |  | CCCR/Mickey Mouse
11556 |  |  | AAAT |  |  |  |  | ZZZ w/o I | CCCR | CCCR/ CCCR |  |  | CCCR/Mickey Mouse
1158 |  |  | IIIT |  |  |  |  | ZZZ w/o I | CCCR | VVVR |  |  | VVVR
1158 |  |  | IIIT |  |  |  |  | ZZZ w/o I | DHR | VVVR |  |  | VVVR
1158 |  |  | FFFT |  |  |  |  | ABC w/ I | VVVR | VVVR |  |  | VVVR
1158 |  |  | IIIT |  |  |  |  | BBB | VVVR | VVVR |  |  | VVVR
1158 |  |  | FFFT |  |  |  |  | RRR | CCCR | VVVR |  |  | VVVR
1158 |  |  | IIIT |  |  |  |  | ZZZ w/o I |  | VVVR |  |  | VVVR
1158 |  |  | IIIT |  |  |  |  | ZZZ w/o I | DHR | VVVR |  |  | VVVR
1158 |  |  | IIIT |  |  |  |  | BBB |  | VVVR |  |  | VVVR
10975 |  |  | FFFT |  |  |  |  | ABC w/ I | TPAR | TPAR |  |  | TPAR
10975 |  |  | FFFT |  |  |  |  | RRR | CCCR | TPAR |  |  | TPAR
1407 |  |  | FFFT |  |  |  |  | CD w/o Z | TPAR | No Scenarios |  |  | No Secenarios
1407 |  |  | FFFT |  |  |  |  | ZZZ w/o I | TPAR | No Scenarios |  |  | No Secenarios
1407 |  |  | FFFT |  |  |  |  | ZZZ w/o I | CCCR | No Scenarios |  |  | No Secenarios
1407 |  |  | FFFT |  |  |  |  | FFF | CCCR | No Scenarios |  |  | No Secenarios
1161 |  |  | FFFT |  |  |  |  | ABC w/ I |  | - |  |  | -
1161 |  |  | FFFT |  |  |  |  | RRR |  | - |  |  | -
99999 |  |  | FFFT |  |  |  |  | ABC w/ I | CCCR | CCCR/ TPAR/ DPAC |  |  | CCCR/TPAR/DPAC
99999 |  |  | FFFT |  |  |  |  | ABC w/ I | TPAR | CCCR/ TPAR/ DPAC |  |  | CCCR/TPAR/DPAC
99999 |  |  | FFFT |  |  |  |  | ABC w/ I | DPAC | CCCR/ TPAR/ DPAC |  |  | CCCR/TPAR/DPAC
1130629 |  |  | FFFT |  |  |  |  | ABC w/ I | CCCR |  |  |  | -/CCCR
1130629 |  |  | RRRT |  |  |  |  | RRR | CCCR |  |  |  | -/CCCR
1130629 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR
1130629 |  |  | RRRT |  |  |  |  | RRR |  |  |  |  | -/CCCR
1130629 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR
1130629 |  |  | RRRT |  |  |  |  | RRR |  |  |  |  | -/CCCR
1130629 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR
1130629 |  |  | RRRT |  |  |  |  | RRR |  |  |  |  | -/CCCR
1130629 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR
1130629 |  |  | FFFT |  |  |  |  | RRR |  |  |  |  | -/CCCR
1176202 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -
1176202 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -
1176202 |  |  | FFFT |  |  |  |  | RRR |  |  |  |  | -
1176202 |  |  | AAAT |  |  |  |  | ABC w/ I |  |  |  |  | -
1176202 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -
1176202 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -
1176202 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -
1176202 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -
1176202 |  |  | FFFT |  |  |  |  | RRR |  |  |  |  | -
1176202 |  |  | FFFT |  |  |  |  | RRR |  |  |  |  | -
1180295 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -
1180295 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -
1180295 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -
1180295 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -
1182258 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -
1182258 |  |  | FFFT |  |  |  |  | RRR |  |  |  |  | -
1182258 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -
1207634 |  |  | RRRT |  |  |  |  | RRR |  |  |  |  | -/TPAR
1207634 |  |  | FFFT |  |  |  |  | III | TPAR |  |  |  | -/TPAR
1207634 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/TPAR
1207634 |  |  | FFFT |  |  |  |  | ABC w/ I | TPAR |  |  |  | -/TPAR
1207634 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/TPAR
1212469 |  |  | AAAT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR
1212469 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR
1212469 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR
1212469 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR
1212469 |  |  | FFFT |  |  |  |  | RRR |  |  |  |  | -/CCCR
1212469 |  |  | FFFT |  |  |  |  | ABC w/ I | CCCR |  |  |  | -/CCCR
1212469 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR
1212469 |  |  | FFFT |  |  |  |  | RRR |  |  |  |  | -/CCCR
188 |  |  | RRRT |  |  |  |  | RRR |  |  |  |  | -/CCCR
188 |  |  | FFFT |  |  |  |  | III |  |  |  |  | -/CCCR
188 |  |  | FFFT |  |  |  |  | ABC w/ I | CCCR |  |  |  | -/CCCR
188 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR
188 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR
1205610 |  |  | IIIT |  |  |  |  | CCCR | CCCR |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | IIIR | CCCR |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | ABC w/ I | CCCR |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | IIIR |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | IIIT |  |  |  |  | CCCR |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | IIIR |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | ABC w/ I | CCCR |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | IIIR |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | IIIT |  |  |  |  | CCCR |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | IIIT |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | IIIT |  |  |  |  | CCCR |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | IIIT |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | IIIT |  |  |  |  | CCCR |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | IIIR |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | IIIT |  |  |  |  | CCCR |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | IIIR |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | IIIT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | IIIR |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | IIIT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | ABC w/ I | DPAC |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | IIIR |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | IIIT |  |  |  |  | ABC w/ I |  |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | ABC w/ I | VVVR |  |  |  | -/CCCR/DPAC/VVVR
1205610 |  |  | FFFT |  |  |  |  | IIIR |  |  |  |  | -/CCCR/DPAC/VVVR
1190945 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/VVVR
1190945 |  |  | FFFT |  |  |  |  | ABC w/ I | VVVR |  |  |  | -/VVVR
1190945 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/VVVR
1190945 |  |  | FFFT |  |  |  |  | ABC w/ I | VVVR |  |  |  | -/VVVR
1204922 |  |  | RRRT |  |  |  |  | RRRT |  |  |  |  | -/DPAC
1204922 |  |  | FFFT |  |  |  |  | IIIT | DPAC |  |  |  | -/DPAC
1204922 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/DPAC
1204922 |  |  | FFFT |  |  |  |  | ABC w/ I | DPAC |  |  |  | -/DPAC
1204922 |  |  | FFFT |  |  |  |  | ABC w/ I |  |  |  |  | -/DPAC