Thank you, Ashish. The recommended article is wonderful, but the printout
(or saved .PDF) cuts off the longer formula samples. Is there a way to save
the article to hard disk so that the example formulas can be fully
displayed?

Thanks,
Richard

************
"Ashish Mathur" wrote in message
...
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?