Hello,

I need to find all the text strings, which matches to certain criteria.
Briefly, I have a criterium "test". Then, I'm interested in the rows which
have "test" string in a column B. I'm looking for the text strings in the
column C, which correspond the rows according to "test" criterium. I have to
eliminate all the duplicate and blank values and finally concatenate rest of
the values.

VLOOKUP just returns the first match, which can even be blank. In theory, I
could use the OFFSET and MATCH -functions for all the matches, changing the
reference to correspond the next row from the previous match and continue.
However, there are so many matches that it would be impossible to link so
many loops.

DGET would be an ideal function, only if it could handle the multiple
matches. If there was an IS-function to #NUM!- and #VALUE errors
particularly, I could determine, if there are matches for the criteria.

Array functions don't seem to solve this problem either, because the rows
which corresponds the criterium are in disorder, so I can't get an array,
which would correspond the criterium.