Add a Lookup Table

The Add Lookup Table Tool creates a new object of type Lookup Table which evaluates each row in the table until a true comparison is found in the 'Comparison Columns' then the assignment is made using the 'Assignment Columns'.

For more on Lookup Tables