Extracting all matches
 

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?

Extracting all matches
 

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?

Extracting all matches
 

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?