Changes between Version 11 and Version 12 of UserGuidelines/Importer/Excel

Timestamp:

03/20/20 20:46:11 (5 years ago)

Author:

Fran Boon

Comment:

--

UserGuidelines/Importer/Excel

@@ -24 +24 @@
 =IF(L2_Selected="", L1s, INDIRECT("FakeList"))
 }}}
-Simple L2s based on L1
+
+Simple L2s based on a single L1
 * NB Dependent Lists must be sorted by dependency
 {{{
@@ -33 +34 @@
 =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
+
+Simple L3s based on a single L2
 * !ToDo: Multi-level lookups (Where L2s not Unique!)
-* !ToDo: Can we prevent changes if any Fokontany selected?
+* !ToDo: Can we prevent changes if any L4 selected?
 {{{
 =OFFSET(L3_Start,MATCH(L2_Selected,L2s_for_L3,0),0,COUNTIF(L2s_for_L3,L2_Selected),1)
 }}}
-Simple L4s based on L3
+
+Simple L4s based on a single L3
 * !ToDo: Multi-level lookups (Where L2s not Unique!)
 {{{