We need to find all the cells in a column that match a certain criteria and
then extract the associated value in a second column. Both the lookup
column and the extraction column are text. SUMIF( ) might work, but we also
want to know if there is a lookup function that can find more than one
value, if the criteria is met.

Finally, regardless of the method used above, is there a way to save the
resulting values (text) as an array or in a similar format whereby the
separate values (text) could be concatenated or otherwise manipulated?