| 9 | |
| 10 | == Lookup Lists == |
| 11 | # Simple L1s |
| 12 | =L1s |
| 13 | # Prevent modifying the L1 again if the L2 has been selected |
| 14 | =IF(L2_Selected="", L1s, INDIRECT("FakeList")) |
| 15 | # Simple L2s based on L1 |
| 16 | =OFFSET(L2_Start,MATCH(L1_Selected,L1s_for_L2,0),0,COUNTIF(L1s_for_L2,L1_Selected),1) |
| 17 | # With prevention |
| 18 | =IF(L3_Selected="", OFFSET(L2_Start,MATCH(L1_Selected,L1s_for_L2,0),0,COUNTIF(L1s_for_L2,L1_Selected),1), INDIRECT("FakeList")) |
| 19 | # Simple L3s based on L2 |
| 20 | # @ToDo: Multi-level lookups (Where L2s not Unique!) |
| 21 | =OFFSET(L3_Start,MATCH(L2_Selected,L2s_for_L3,0),0,COUNTIF(L2s_for_L3,L2_Selected),1) |
| 22 | # @ToDo: Can we prevent changes if any Fokontany selected? |
| 23 | # Simple L4s based on L3 |
| 24 | # @ToDo: Multi-level lookups (Where L2s not Unique!) |
| 25 | =OFFSET(L4_Start,MATCH(L3_Selected,L3s_for_L4,0),0,COUNTIF(L3s_for_L4,L3_Selected),1) |
| 26 | |
| 27 | Dependent Lists must be sorted by dependency |