Changes between Version 4 and Version 5 of UserGuidelines/Importer/Excel

Timestamp:

10/28/15 10:52:33 (10 years ago)

Author:

Fran Boon

Comment:

--

UserGuidelines/Importer/Excel

@@ -10 +10 @@
 == Lookup Lists ==
 # Simple L1s
-{{
+{{{
 =L1s
-}}
+}}}
 # Prevent modifying the L1 again if the L2 has been selected
-{{
+{{{
 =IF(L2_Selected="", L1s, INDIRECT("FakeList"))
-}}
+}}}
 # Simple L2s based on L1
-{{
+{{{
 =OFFSET(L2_Start,MATCH(L1_Selected,L1s_for_L2,0),0,COUNTIF(L1s_for_L2,L1_Selected),1)
-}}
+}}}
 # With prevention
-{{
+{{{
 =IF(L3_Selected="", OFFSET(L2_Start,MATCH(L1_Selected,L1s_for_L2,0),0,COUNTIF(L1s_for_L2,L1_Selected),1), INDIRECT("FakeList"))
-}}
+}}}
 # Simple L3s based on L2
 # @ToDo: Multi-level lookups (Where L2s not Unique!)
-{{
+{{{
 =OFFSET(L3_Start,MATCH(L2_Selected,L2s_for_L3,0),0,COUNTIF(L2s_for_L3,L2_Selected),1)
-}}
+}}}
 # @ToDo: Can we prevent changes if any Fokontany selected?
 # Simple L4s based on L3
 # @ToDo: Multi-level lookups (Where L2s not Unique!)
-{{
+{{{
 =OFFSET(L4_Start,MATCH(L3_Selected,L3s_for_L4,0),0,COUNTIF(L3s_for_L4,L3_Selected),1)
-}}
+}}}
 
 Dependent Lists must be sorted by dependency