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


Ignore:
Timestamp:
10/28/15 10:52:33 (7 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/Importer/Excel

    v4 v5  
    1010== Lookup Lists ==
    1111# Simple L1s
    12 {{
     12{{{
    1313=L1s
    14 }}
     14}}}
    1515# Prevent modifying the L1 again if the L2 has been selected
    16 {{
     16{{{
    1717=IF(L2_Selected="", L1s, INDIRECT("FakeList"))
    18 }}
     18}}}
    1919# Simple L2s based on L1
    20 {{
     20{{{
    2121=OFFSET(L2_Start,MATCH(L1_Selected,L1s_for_L2,0),0,COUNTIF(L1s_for_L2,L1_Selected),1)
    22 }}
     22}}}
    2323# With prevention
    24 {{
     24{{{
    2525=IF(L3_Selected="", OFFSET(L2_Start,MATCH(L1_Selected,L1s_for_L2,0),0,COUNTIF(L1s_for_L2,L1_Selected),1), INDIRECT("FakeList"))
    26 }}
     26}}}
    2727# Simple L3s based on L2
    2828# @ToDo: Multi-level lookups (Where L2s not Unique!)
    29 {{
     29{{{
    3030=OFFSET(L3_Start,MATCH(L2_Selected,L2s_for_L3,0),0,COUNTIF(L2s_for_L3,L2_Selected),1)
    31 }}
     31}}}
    3232# @ToDo: Can we prevent changes if any Fokontany selected?
    3333# Simple L4s based on L3
    3434# @ToDo: Multi-level lookups (Where L2s not Unique!)
    35 {{
     35{{{
    3636=OFFSET(L4_Start,MATCH(L3_Selected,L3s_for_L4,0),0,COUNTIF(L3s_for_L4,L3_Selected),1)
    37 }}
     37}}}
    3838
    3939Dependent Lists must be sorted by dependency