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


Ignore:
Timestamp:
03/20/20 20:34:08 (5 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • UserGuidelines/Importer/Excel

    v10 v11  
    1010== Lookup Lists ==
    1111Simple L1s
     12- define a Named Range
     13- select the column
     14- deselect the header
     15- Data | Data Validation
     16- List | Source:
     17
    1218{{{
    1319=L1s
    1420}}}
     21
    1522Prevent modifying the L1 again if the L2 has been selected
    1623{{{
    … …  
    2734}}}
    2835Simple L3s based on L2
    29 * ToDo: Multi-level lookups (Where L2s not Unique!)
    30 * @ToDo: Can we prevent changes if any Fokontany selected?
     36* !ToDo: Multi-level lookups (Where L2s not Unique!)
     37* !ToDo: Can we prevent changes if any Fokontany selected?
    3138{{{
    3239=OFFSET(L3_Start,MATCH(L2_Selected,L2s_for_L3,0),0,COUNTIF(L2s_for_L3,L2_Selected),1)
    3340}}}
    3441Simple L4s based on L3
    35 * @ToDo: Multi-level lookups (Where L2s not Unique!)
     42* !ToDo: Multi-level lookups (Where L2s not Unique!)
    3643{{{
    3744=OFFSET(L4_Start,MATCH(L3_Selected,L3s_for_L4,0),0,COUNTIF(L3s_for_L4,L3_Selected),1)