ConcatIF Function

CONCATIF() Description

The CONCATIF() function is designed to concatenate text from different cells according to a given condition.

Main Characteristics of the CONCATIF Function

Syntax:

=CONCATIF(LookupValue; LookupArray; ReturnArray; [Delimiter])

Parameters:

• LookupValue: The value we are looking for.
• LookupArray: The column in which we search.
• ReturnArray: The column from which we return the related value.
• [Delimiter]: Optional. Delimiter for found values. By default, a semicolon (;) is used.

Example of Use

The CONCATIF() function is simple to use. You just need to specify the search range and the column from which values will be taken, and Excel (Calc) will automatically combine all common values into one cell using the specified delimiter:

=CONCATIF(LookupValue; {Lookup Array}; {Return Array}; Delimiter)

We will get the following result:

In this example, the following values are used:

• LookupValue: A3 - The value we are looking for ("John").
• LookupArray: A9:A18 - Search range ({Lookup Array}).
• ReturnArray: B9:B18 - The range from which we return values ({Return Array}).
• Delimiter: - We use a comma with a space as a delimiter (", ").

Download extension

You can use the function CONCATIF() by installing the YLC Utilities extension.

After that, this function will be available in all files that will be opened in Excel (LibreOffice Calc).