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


Ignore:
Timestamp:
03/20/20 20:46:11 (19 months ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/Importer/Excel

    v11 v12  
    2424=IF(L2_Selected="", L1s, INDIRECT("FakeList"))
    2525}}}
    26 Simple L2s based on L1
     26
     27Simple L2s based on a single L1
    2728* NB Dependent Lists must be sorted by dependency
    2829{{{
     
    3334=IF(L3_Selected="", OFFSET(L2_Start,MATCH(L1_Selected,L1s_for_L2,0),0,COUNTIF(L1s_for_L2,L1_Selected),1), INDIRECT("FakeList"))
    3435}}}
    35 Simple L3s based on L2
     36
     37Simple L3s based on a single L2
    3638* !ToDo: Multi-level lookups (Where L2s not Unique!)
    37 * !ToDo: Can we prevent changes if any Fokontany selected?
     39* !ToDo: Can we prevent changes if any L4 selected?
    3840{{{
    3941=OFFSET(L3_Start,MATCH(L2_Selected,L2s_for_L3,0),0,COUNTIF(L2s_for_L3,L2_Selected),1)
    4042}}}
    41 Simple L4s based on L3
     43
     44Simple L4s based on a single L3
    4245* !ToDo: Multi-level lookups (Where L2s not Unique!)
    4346{{{