The FINDITEM function searches a list for a matching item using a text input. If a match is found, it returns the corresponding item from the list.

For example, you could use the FINDITEM function to determine whether an item available in one region exists in a list of items available in other regions.

Syntax

FINDITEM(List, Text)

Arguments

ArgumentData typeDescription
ListListThe list to search within. This is where the function looks for a match with the text input.
TextTextThe text to match against the name or code of an item in the list.

The FINDITEM function returns a result of the list data type, based on the given List argument.

Calculation engine functionality differences

BehaviorClassicPolaris
Usage on the Time dimensionYou can use FINDITEM on the Time dimension.You can't use FINDITEM on the Time dimension.
Line items with Formula or Ratio summary methodCan be used for line items with Formula or Ratio summary methods.Can't be used for line items with Formula or Ratio summary methods.

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

LOOKUP

Examples