LOOKUP

Retrieves values from a target column in a list by matching one or more columns between the planning list and the target list.

Syntax: LOOKUP (column name,match_condition_1, ... , match_condition_n)

• column_name where the values are to be retrieved from.

• match_condition_1, ... , match_condition_n : each match_condition contains two values on either side of an equals (==) operator—the left side contains the column_name from the planning table and the right side contains the corresponding column_name from the list where the target column_name is present.

For example, consider the Employee roster list and the Hike percentage list below.

The columns in the Employee roster list are: Employee ID | Employee | Hire Date | Termination Date | Position Start Date | Position End Date | Title | Department | Employment Status | Annual Salary Equivalent | Annual Bonus | Full Name | Annual salary equivalent Currency

Say, the Hike percentage list contains just two columns: Emp ID | Hike, where Emp ID has equivalent values as Employee ID from the Employee roster dataset and Hike contains the hike percentage values.

To compute the hikes for each employee, you can create a variable and use the LOOKUP function to accomplish it.

Example: ( LOOKUP (Hike,Employee ID == Emp ID ) + 1 ) * Salary