=LISTINTERSECT

The =LISTINTERSECT() function compares two semicolon-separated lists and returns only the entries that appear in both lists.

Syntax

=LISTINTERSECT(SemicolonSeparatedList1; SemicolonSeparatedList2)

Parameters

• SemicolonSeparatedList1
  The first semicolon-separated list to compare.

• SemicolonSeparatedList2
  The second semicolon-separated list to compare against the first list.

How It Works

• Reads both inputs as semicolon-separated lists

• Compares each entry in the first list to entries in the second list

• Selects only values that exist in both lists

• Returns the matching values as a semicolon-separated list

Usage Notes

• Matching is based on exact text values

• Order of returned values follows their order in the first list

• If no matching values exist, an empty result is returned

• Formula functions are case sensitive and must be in ALL CAPS

Example

If the List A field contains:

Entry1; Entry2; Entry3

and the List B field contains:

Entry2; Entry3; Entry4

then:

=LISTINTERSECT([[Field: List A (Text)]]; [[Field: List B (Text)]])

Returns

Entry2; Entry3

---

Keywords

LISTINTERSECT, list intersection, semicolon list, list comparison, matching values, text functions, formula function, calculated value