Spreadsheet: 711346d1609627943-multiple-ifs-multiple-conditions-multiple-choices-big-excel-problem
Sheet: Sheet1

ORIGINAL |  |  |  |  |  |  |  |  |  |  | SOLUTION
Fiscal year | Fiscal year/period | Order | D1 | D2 | Type | BU | INSTRUCTIONS :)  1. GREEN GETS CARRIED DOWN TO BOTTOM OF TABLE  2. ALL BLUE IS FILLED OUT TO MATCH THE ABOVE ORDER NUMBER IF THEY ARE THE SAME   I.E ROW 21 WILL = ROW 20 SINCE ALL BLANK I.E ROW 29 WILL = ROW 28 SINCE ORDER NUMBER IS THE SAME  3. HARDEST THING! FOR EACH ORDER NUMBER THERE CAN ONLY BE ONE TYPE OF "ORDER TYPE"  I. ROW 7 HAS THE SAME ORDER TYPE AS ROW 6 THEREFORE "NOT ASSIGNED" WILL HAVE TO BECOME "helo" - SIMILIAR TO 23 AND 24 |  |  |  | Fiscal year | Fiscal year/period | Order | D1 | D2 | Type | BU
1990 | 1 | [PHONE] | a | 4673 | Not assigned | ZS24 |  |  |  |  | V0/2021 | 001/2021 | [PHONE] | a | 4673 | Not assigned | ZS24
 |  | [PHONE] | b | 4673 | Not assigned |  |  |  |  |  | 1990 | 1 | [PHONE] | b | 4673 | Not assigned | ZS24
 |  | [PHONE] | c | 4823 | Not assigned | ZS24 |  |  |  |  | 1990 | 1 | [PHONE] | c | 4823 | Not assigned | ZS24
 |  | [PHONE] | d | 4489 | [NAME] | ZS24 |  |  |  |  | 1990 | 1 | [PHONE] | d | 4489 | [NAME] | ZS24
 |  | [PHONE] |  |  | Not assigned | ZS24 |  |  |  |  | 1990 | 1 | [PHONE] | d | 4489 | [NAME] | ZS24
 |  | [PHONE] | b | 4917 | Not assigned | ZS24 |  |  |  |  | 1990 | 1 | [PHONE] | b | 4917 | Not assigned | ZS24
 |  |  |  |  |  |  |  |  |  |  | 1990 | 1 | [PHONE] | b | 4917 | Not assigned | ZS24
 |  | [PHONE] | d | NGIO | Not assigned | ZS54 |  |  |  |  | 1990 | 1 | [PHONE] | d | NGIO | Not assigned | ZS24
 |  | [PHONE] | a | 5000 | Not assigned | ZS54 |  |  |  |  | 1990 | 1 | [PHONE] | a | 5000 | Not assigned | ZS24
 |  | [PHONE] | b | 6181 | Not assigned | ZS24 |  |  |  |  | 1990 | 1 | [PHONE] | b | 6181 | Not assigned | ZS24
 |  | [PHONE] | c | 500 | Not assigned | ZS54 |  |  |  |  | 1990 | 1 | [PHONE] | c | 500 | Not assigned | ZS24
 |  | [PHONE] | d | ORUM | Not assigned | ZS54 |  |  |  |  | 1990 | 1 | [PHONE] | d | ORUM | Not assigned | ZS24
 |  | [PHONE] | a | III | Not assigned | ZS54 |  |  |  |  | 1990 | 1 | [PHONE] | a | III | Not assigned | ZS24
 |  | [PHONE] | b | ULTI | Not assigned | ZS54 |  |  |  |  | 1990 | 1 | [PHONE] | b | ULTI | Not assigned | ZS24
 |  |  |  | ULTI | Not assigned |  |  |  |  |  | 1990 | 1 | [PHONE] | b | ULTI | Not assigned | ZS24
 |  | [PHONE] | d | 6497 | Not assigned | ZS24 |  |  |  |  | 1990 | 1 | [PHONE] | d | 6497 | Not assigned | ZS24
 |  | [PHONE] | a | R Z1 | Not assigned | ZS24 |  |  |  |  | 1990 | 1 | [PHONE] | a | R Z1 | Not assigned | ZS24
 |  | [PHONE] | b | ULTI | Not assigned | ZS54 |  |  |  |  | 1990 | 1 | [PHONE] | b | ULTI | Not assigned | ZS24
 |  |  |  |  |  |  |  |  |  |  | 1990 | 1 | [PHONE] | b | ULTI | Not assigned | ZS24
 |  | [PHONE] | d | 700 | Not assigned | ZS54 |  |  |  |  | 1990 | 1 | [PHONE] | d | 700 | Not assigned | ZS24
 |  | [PHONE] | a | 740 | Not assigned | ZS54 |  |  |  |  | 1990 | 1 | [PHONE] | a | 740 | Not assigned | ZS24
 |  | [PHONE] | b |  | new years | ZS54 |  |  |  |  | 1990 | 1 | [PHONE] | b | 740 | Not assigned | ZS24
 |  | [PHONE] | c | 5000 | Not assigned | ZS54 |  |  |  |  | 1990 | 1 | [PHONE] | c | 5000 | Not assigned | ZS24
 |  | [PHONE] | d | ORUM | Not assigned | ZS54 |  |  |  |  | 1990 | 1 | [PHONE] | d | ORUM | Not assigned | ZS24
 |  | [PHONE] | a | ORUM | Not assigned | ZS54 |  |  |  |  | 1990 | 1 | [PHONE] | a | ORUM | Not assigned | ZS24
 |  | [PHONE] | c | X 5 | Not assigned | ZS24 |  |  |  |  | 1990 | 1 | [PHONE] | c | X 5 | Not assigned | ZS24
 |  |  |  |  |  |  |  |  |  |  | 1990 | 1 | [PHONE] | c | X 5 | Not assigned | ZS24
 |  |  |  |  |  |  |  |  |  |  | 1990 | 1 | [PHONE] | c | X 5 | Not assigned | ZS24
 |  | [PHONE] | b | 600 | Not assigned | ZS54 |  |  |  |  | 1990 | 1 | [PHONE] | b | 600 | Not assigned | ZS24