HLOOKUP function
This topic describes the formula syntax and usage of the HLOOKUP function in the Data Quality Execute Formula transform.
Description
Looks in the top row of an array and returns the value of the indicated cell.
Syntax
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])