Combine two tables of data together based on a key
Function:
Vlookup(table = string, lookup_col = string, lookup_table = string, match_on = string, return_cols = list)
Parameters:
Table: Table name on which to perform function
Lookup Column: Column to use to lookup values
Table: Table to join to the original table
Match Column: Column to match for the Vlookup
Columns to Return: Columns to return from the joined table
Examples:
Vlookup(table = Budget, lookup_col = "Geo", lookup_table = Expense Report, match_on = "Geography", return_cols = ["Actuals", "Plan", "Business Unit")