DGet function

[Jim H]

Is there a function or technique that behaves like the DGET
function but is able to return multiple values that match
the criterion instead of just one.

 

[Peo Sjoblom]

Advanced filter is one technique,it is also similar to DGET the way it is
set up.
There are some fairly complicated formulas using a combination of
index and small that you can use to extract multiple hits...
Also the autofilter could probably be used in most cases..

 

[Paul]

Is there a function or technique that behaves like the DGET
function but is able to return multiple values that match
the criterion instead of just one.

It depends what you want to do with the multiple returns. If you actually
want to see them individually, you could look here in the paragraph
"Arbitrary Lookups":
http://www.cpearson.com/excel/lookups.htm
But you might be better off sorting your data rather than trying to extract
matching data.

However, if you want (for example) to sum the matching returns, you can use
SUMPRODUCT, which can take as many criteria as you wish, like this:
=SUMPRODUCT( (A1:A1000=criterion1) * (B1:B1000>criterion2) * (C1:C1000))

 

[Aladin Akyurek]

And a recent reformulation with Index, Match, etc...

http://www.mrexcel.com/board2/viewtopic.php?t=73376