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.

FINDITEM(List, Text)

ArgumentData typeDescription
ListListThe list to search within. This is where the function looks for a match for the text input.
TextTextThe 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.

In Polaris, you can't use the FINDITEM function on Time, whereas in Classic Engine, you can.

FINDITEM(Country, Country text)

You must set the data type of the result line item to List, configured with the same list.

LOOKUP

The following is a list named Country, as viewed from the Grid View under General lists.


ParentCode
      USAmericasUS
      CanadaAmericasCA
      MexicoAmericasMX
   AmericasAll RegionsAMER
      UKEuropeGB
      FranceEuropeFR
      SpainEuropeES
   EuropeAll RegionsEMEA
      AustraliaAsia PacificAU
      IndiaAsia PacificIN
      JapanAsia PacificJP
   Asia PacificAll RegionsAPAC
All Regions

The following examples use Text and Code as input values to search within the Country list.


Jan 22Feb 22Mar 22Apr 22May 22Jun 22
TextUSSpainNew ZealandKubekIndiaAlberta
FINDITEM(Country, Text)USSpain


Alberta

Jan 22Feb 22Mar 22Apr 22May 22Jun 22
CodeFRAPINCA-ABUSCA-IN
FINDITEM(Country, Code)France
India
USA