CL_G_VlookupTable

Vlookup Table

Description:

Do advanced Vlookup in a formatted list table, based on item names instead of the column number. allow more readable and easy data checking

Advantages compared to Vlookup:

• The reference column does not necessarily be the first column, you can check any column now.

• Use column names instead of column numbers for the return value, which means more readable and you can edit the data table by adding removing columns without influencing the results.

• Easy to use, you can copy the same code across the excel with the same aimtable

The parameter list:

Parameters	Explanation	Data Type
lookupvalue	the value to be looked up
Aim_table	the table contains the data to be looked up, must be a formatted table (Home> Styles > Format as table)
Aim_name	[optional] the column name where the return values are defined. The function takes the column name of the current cell location
Ref_name	[optional] the column name where the reference values are defined. by default takes the column name of the lookup value.

Video guide:

How it works:

VlookupTable function by default looks up the row of "look up value" in the Aim table, and returns the data in the same column name of "calling cell". Thus it is better to set the same column names in the calling table and aim table. In the case, you can apply the same function across the excel table range, due to the column names are automatically mathed.

However, if the columns are different in the calling table and aim table, you can also declare it in the third and fourth optional parameters.