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


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

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/Importer/Excel

    v3 v4  
    1010== Lookup Lists ==
    1111# Simple L1s
     12{{
    1213=L1s
     14}}
    1315# Prevent modifying the L1 again if the L2 has been selected
     16{{
    1417=IF(L2_Selected="", L1s, INDIRECT("FakeList"))
     18}}
    1519# Simple L2s based on L1
     20{{
    1621=OFFSET(L2_Start,MATCH(L1_Selected,L1s_for_L2,0),0,COUNTIF(L1s_for_L2,L1_Selected),1)
     22}}
    1723# With prevention
     24{{
    1825=IF(L3_Selected="", OFFSET(L2_Start,MATCH(L1_Selected,L1s_for_L2,0),0,COUNTIF(L1s_for_L2,L1_Selected),1), INDIRECT("FakeList"))
     26}}
    1927# Simple L3s based on L2
    2028# @ToDo: Multi-level lookups (Where L2s not Unique!)
     29{{
    2130=OFFSET(L3_Start,MATCH(L2_Selected,L2s_for_L3,0),0,COUNTIF(L2s_for_L3,L2_Selected),1)
     31}}
    2232# @ToDo: Can we prevent changes if any Fokontany selected?
    2333# Simple L4s based on L3
    2434# @ToDo: Multi-level lookups (Where L2s not Unique!)
     35{{
    2536=OFFSET(L4_Start,MATCH(L3_Selected,L3s_for_L4,0),0,COUNTIF(L3s_for_L4,L3_Selected),1)
     37}}
    2638
    2739Dependent Lists must be sorted by dependency