Hi,

You may try my solution here -
http://office.microsoft.com/en-us/ex...CL100570551033

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Blue Max" wrote in message
...
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?