Table of Contents
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)