Miscellaneous utilities

LOOKUP – Select matching value from another field

73 views June 1, 2018 admin 0

Overview

This Custom Field searches a field in each record and then returns a value for another field. It handles multiple matches.

Syntax

LOOKUP(SearchString, SearchField,ReturnField,DataSource)

Element Description
SearchString
The record to search.
SearchField The field within the record to search.
ReturnField The return field
DataSource The name of the data source file.

Example

LOOKUP(FIELDSTR(ID), ID, ‘Description,Price’, accessories.xls)

See also

Was this helpful?