Thanks. Now it is working.
There would still be a last problem where I would like to use CONCATIFS (see the attached file below).
So, there are three columns in this file: Motivation, Names and...
Type: Posts; User: pub
Thanks. Now it is working.
There would still be a last problem where I would like to use CONCATIFS (see the attached file below).
So, there are three columns in this file: Motivation, Names and...
I put the code in a VBA module. How can I check if it's a standard module?
Thanks for the reply but it does not work.
I updated the existing module using the VBA code above but when I try to use the two recommended formulas, it displays: #NAME?
So, what's the reason for...
@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...
I replaced "!!!" with "?". Now, can you give me a solution to my issue ?
I have tried to implement the VBA below (I found it in this forum) in the attached excel file, but does not work with two search criteria !!! Please, some help.
Function Multi_LookUpConcat(ByVal...