LOOKUP(remote_table,remote_result_column,current_match_column, remote_match_column)
Matches the current value with another value from a remote table.  The result will be the value in remote_result_column for which the corresponding remote_match_column equals the current_match_column.