Skip to main content

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

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} ) )

Thx,

now it worked fine for me!

Reply


Terms & Conditions