Find or Search Problem

[Jepedaja]

Hey everybody,

I am trying to match 2 columns to see if a name from column 2 appears in column 1 (list of names). The answer I need is simply true or false.
Column 1 is a lookup field with a name.

• Example: “Smith, Jack”.

And column 2 is a list of names. Example:

• “Green, Mike”, “Smith, Jack”.

But neither with Find nor Search do I get a match. My formulas are:

Column 1:

Column 2:

Formula:

FIND({Mitarbeiter (from Urlaub bestätigt 3)},{Kolonnen Zusammensetzung})

Maybe you have an idea, whats wrong here.

Best greetings

Jepe

[Alexey_Gusev]

Hi,
It's because lookup is array. In some cases it happens with any array values, like multiple-select, more often with lookup, but usually it performs ok, converting array to string on a fly,  to check condition.
If it's not OK, you should explicitly convert array to string - add empty string or wrap into CONCATENATE().

For example: ( '' - two single quotes, equally to two double quotes"", means empty string )

FIND( '' & {Mitarbeiter (from Urlaub bestätigt 3)} , CONCATENATE( {Kolonnen Zusammensetzung} ) )

[Jepedaja]

Thx,

now it worked fine for me!