The FINDITEM function searches for a matching item in a list using a text input. If a match is found, it returns the corresponding list item.
For example, you could use the FINDITEM function to check if an item available in a certain region is available in other regions.
Syntax
FINDITEM(List, Text)
Arguments
Argument | Data type | Description |
List | List | The list to search within. This is where the function looks for a match for the text input. |
Text | Text | The text to match against the name or code of a list item. |
The FINDITEM function returns a result of the list data type, based on the given List argument.
Calculation engine functionality differences
In Polaris, you can't use the FINDITEM function on Time, whereas in Classic Engine, you can.
Syntax example
FINDITEM(Country, Country text)
Constraints
Configuration of the result line item
You must set the data type of the result line item to List, configured with the same list.
Excel equivalent
Examples
The following is a list named Country, as viewed from the Grid View under General lists.
Parent | Code | |
US | Americas | US |
Canada | Americas | CA |
Mexico | Americas | MX |
Americas | All Regions | AMER |
UK | Europe | GB |
France | Europe | FR |
Spain | Europe | ES |
Europe | All Regions | EMEA |
Australia | Asia Pacific | AU |
India | Asia Pacific | IN |
Japan | Asia Pacific | JP |
Asia Pacific | All Regions | APAC |
All Regions |
List examples
The following examples use Text and Code as input values to search within the Country list.
Jan 22 | Feb 22 | Mar 22 | Apr 22 | May 22 | Jun 22 | |
Text | US | Spain | New Zealand | Kubek | India | Alberta |
FINDITEM(Country, Text) | US | Spain | Alberta |
Jan 22 | Feb 22 | Mar 22 | Apr 22 | May 22 | Jun 22 | |
Code | FR | AP | IN | CA-AB | US | CA-IN |
FINDITEM(Country, Code) | France | India | USA |