Civil LAB - Excel
  • What is CIVIL LAB Excel?
  • Introduction
    • How to use ? Installation
    • Introduction of the modules
    • Copy right agreement
  • Documentation
    • Ribbon Tools
      • Formatting tools
        • Color It
        • Advanced Formatting
        • Auto Units
        • Group color
      • Utilization Tools
        • Pro copy
        • Level Sum
      • EuroCode Tools
        • Eurocode 4
        • Eurocode 3
        • Eurocode 2
          • Creep Coefficient
        • Eurocode 0 & 1
      • Database tools
        • Engineer Database
        • Group to index
        • Index to group
    • Built-in functions
      • General Functions
        • CL_G_TabelInterpolation
        • CL_G_CreateListTablePicker
        • CL_G_ListTableFind
        • CL_G_Table_find
        • CL_G_VlookupTable
      • Database Function
      • Eurocode function
      • Mechanical functions
        • CL_M_Rebars_A
        • CL_M_Recdata
        • CL_M_HProfileData
        • CL_M_Zel
    • Ready made Excel
      • Parametric tool : input output
      • Composite beam stiffness
    • Excel-Python
  • Contacts and development
    • For Programmers
      • Civil LAB framework
      • Resources
      • Naming Rules
      • Guides to Function Modules
      • Guides to Data Tables
      • Guides to Ribbons
    • For Engineers
      • What is possible?
    • For Supporter
      • Donation / contribution
    • Contact infomation
  • 💾Downloads
  • Road map
    • Road Map
Powered by GitBook
On this page
  1. Documentation
  2. Built-in functions
  3. General Functions

CL_G_CreateListTablePicker

Create ListTable dropdown list

PreviousCL_G_TabelInterpolationNextCL_G_ListTableFind

Last updated 3 years ago

Description:

Table picker to generate a dropdown list of table list rows or columns, (data must be formatted as a table by home> styles> format as table)

best to use together with to do automatic checking of data in a 2D table replace the default "Vlookup" function

The parameter list:

Parameters
Explanation
Data Type

table

the table range, must be formatted table

direction

[optional] the "row" / ''r" / 0 or "column" / "c"/1, default is Row

offset

[optional] the offset of columns if the direction is set as column, default as 0

Video guide:

CL_G_ListTableFind