How can I get DGET to return all records that meet the criteria?

[Eddie A]

I was able to get this function to work, but it only returns 1 record when
there can be many. If my criteria so happens to be a unique record, it
works. However, if I it has muliple records that match, i get a #NUM! Error.
Help will be greatly appreciated.
(e-mail address removed)

 

[John C]

The inherent function of DGET is that if multiple records meet the criteria,
you get the error. Do a search In: Excel Worksheet Functions. Search for: get
multiple records. There is a thread titled Using DGET to extract multiple
records that you may find useful. (Note: They didn't use DGET).