Extracting all matches

  • Thread starter Thread starter Blue Max
  • Start date Start date
B

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?
 
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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

With F1 value, look at A, if match or partial match return B 5
Lookup against concatenated source value 2
Index and Match 8
match formula 2
Lookups & match ???? 7
Index Match on Columns and Rows 0
return proper match from three columns 2
Is there a way to extract multiple values from an INDEX result ? 3

Back
Top