Extracting all matches

[Blue Max]

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?

 

[Ashish Mathur]

Hi,

You may try my solution here -
http://office.microsoft.com/en-us/excel/HA012260381033.aspx?pid=CL100570551033

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Blue Max]

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

************