Returns data from a specific column in a data extension. To call this function, you supply the name of the column to search, the value to match, and the column to return.

If your search criteria return more than one result, the system returns the first matching value it finds. For this reason, it's best to use this function to search for unique identifiers. If your search criteria could match more than one row in the data extension, use LookupRows() to retrieve an entire rowset, and then parse the rowset.

  • dataExt (string): Required. The name of the data extension that contains the data that you want to retrieve.
  • returnColumn (string): Required. The name of the column to return data from.
  • searchColumn1 (string): Required. The name of the column to search for rows to retrieve. This value is case-sensitive.
  • searchValue1 (string): Required. The value that identifies the rows to retrieve. This value is case-sensitive.

You can optionally append additional search columns and values to the end of the parameter string.

This example uses a data extension called "Regions of Japan," which contains the data in this table.


This code searches for a row in which the value of the NameEN column is Kanto. It then returns the value in the NameJA column for that row.

The code example outputs the value of the specified column.