Welcome to Catalog Tips
Search more than 200 articles to learn more about creating and automating your product catalogs
Tip: Start typing in the input box for immediate search results.
LOOKUP – Select matching value from another field
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)