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


Ignore:
Timestamp:
10/28/15 10:51:10 (8 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/Importer/Excel

    v2 v3  
    77
    88Normally this is a hidden worksheet with a user-visible UI worksheet where data is entered & 1 or more lookup worksheets.
     9
     10== Lookup Lists ==
     11# Simple L1s
     12=L1s
     13# Prevent modifying the L1 again if the L2 has been selected
     14=IF(L2_Selected="", L1s, INDIRECT("FakeList"))
     15# Simple L2s based on L1
     16=OFFSET(L2_Start,MATCH(L1_Selected,L1s_for_L2,0),0,COUNTIF(L1s_for_L2,L1_Selected),1)
     17# With prevention
     18=IF(L3_Selected="", OFFSET(L2_Start,MATCH(L1_Selected,L1s_for_L2,0),0,COUNTIF(L1s_for_L2,L1_Selected),1), INDIRECT("FakeList"))
     19# Simple L3s based on L2
     20# @ToDo: Multi-level lookups (Where L2s not Unique!)
     21=OFFSET(L3_Start,MATCH(L2_Selected,L2s_for_L3,0),0,COUNTIF(L2s_for_L3,L2_Selected),1)
     22# @ToDo: Can we prevent changes if any Fokontany selected?
     23# Simple L4s based on L3
     24# @ToDo: Multi-level lookups (Where L2s not Unique!)
     25=OFFSET(L4_Start,MATCH(L3_Selected,L3s_for_L4,0),0,COUNTIF(L3s_for_L4,L3_Selected),1)
     26
     27Dependent Lists must be sorted by dependency
    928
    1029== Examples ==