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.
CASE – Find given key in list
Overview
This Custom Field finds the given key in a list of key/value pairs and returns the matching value.
Syntax
CASE(FIELDSTR(value),1,ABC,2,DEF,3,GHI)
| Element | Description |
|---|---|
| Text | Text to search |
| Key | Key to search for |
| Value | Matching Value |
Example
CASE(2,1,ABC,2,DEF,3,GHI) returns DEF.