VLOOKUP function

This topic describes the formula syntax and usage of the VLOOKUP function in the Data Quality Execute Formula transform.

Description

Looks in the first column of an array and moves across the row to return the value of a cell.

Syntax

VLOOKUP(lookup_value,table_array,col_index_num,[rang_lookup])

Example