DGET - Formula Returns #NUM! Error (I verified no duplicates)

**wmcgrath** · 09-16-2011, 04:25 PM

To anyone that has encountered this issue, (see attached file)
I am trying to use the database DGET function and I continue to get the error result #NUM! which according to Excel help indicates duplicate values in the database. I reviewed the database by using auto filter on the criteria I entered for the DGET function and only 1 record is returned. So, how can there be a duplicate? I have also had bad results using the DSUM function especially when the criteria has similar items in the field but not a redundant item. Any help would be much appreciated.

**Gazpaxo** · 09-18-2011, 02:04 AM

I am no DGET expert but apparently you do have duplicated values. It is considering BAR-Nominal and BAR-NOMINAL PD as duplicated.

I have called it PD BAR-NOMINAL instead and it works.

**wmcgrath** · 09-21-2011, 02:37 PM

Gazpaxo,
Thank you for looking into my issue; however, I am positive that there is not a duplicate of this record. When I filter the dataset for the following:
ProdTyp = BAR-NOMINAL PD
StudGrade = 660B
measuresystem = IMP
baseunit = IN
Diam = 1 3/8

Only 1 record appears. Hence this is proof that there is no duplicate, correct? I realize that changing a word around e.g. PD BAR-NOMINAL may "trick" DGET into recognizing the criteria; but this seems un useful if the record set is void of duplicates correct? Is there anything else you may be able to advise me of that will pinpoint an error if one exists or prove that DGET is not as robust as I am inclined to believe. Thank you for your time.