Upgrade to LookUpConcat UDF: Search Multiple Criteria and concatenate.

[pub]

@DJE, I've attached below an excel file where I used your VBA code above.
In F1 ... H4 cells I would like name lists (separated by comma) with the values from column C taking into account the two criteria listed in the cells: F1, G1, H1 and E2...E4.

[station]

@DJE, I've attached below an excel file where I used your VBA code above.
In F1 ... H4 cells I would like name lists (separated by comma) with the values from column C taking into account the two criteria listed in the cells: F1, G1, H1 and E2...E4.

Hi,

I tried the multiple lookup_Concat and I get a REF! error

Given the same data in the example XLSX file, I used this formula in cell F3:

=Multi_LookUpConcat("F1;E3",$A$2:$B$50,$C$2:$C$50,";",", ")

F1 and E3 are the two criteria to search for.
$A$2:$B$50 are the columns these data should be found.
$C$2:$C$50 is the range to pull results from

I can only successfully concat with one criteria. Any help would be appreciated.