TOP

ConcatIF function for Excel

CONCATIF() Description

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


Main Features Functions CONCATIF

Syntax:

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

Parameters:

Example Usage

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

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

We will have the following result:

CONCATIF formula usage

This example uses the following values:

Download the extension

You can use the CONCATIF() function by installing a free extension YouLibreCalc.xlam .

After that, this function will be available in all files that will be opened in Excel.