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_Table_find

Table find

PreviousCL_G_ListTableFindNextCL_G_VlookupTable

Last updated 3 years ago

Description:

check data from a two-dimension Table by giving the values in the first row and column name and returning the value.

The parameter list:

Parameters
Explanation
Data Type

Table_Range

the range of the Table. (The first row and first column must be the index of the table)

Row value

the value to match rows in the first column in the vertical direction

Column value

the values to match the column names in the horizontal direction

Video guide: