Excel DGET double match #num error. Windows 7 - XL-07

football

New Member
Joined
Jan 11, 2014
Messages
2
Name
Class
Last
New Average
ImproveHigh SlowHigh TimedX's
Ed
Master
276274-3 84964
Mark
Master276
2782 9095
5
Steve
Master2802800 86
97
5
Nathan
Master275271-4 82974

<colgroup><col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:3474;width:71pt" width="95"> <col style="mso-width-source:userset;mso-width-alt:4644;width:95pt" width="127"> <col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:3401;width:70pt" width="93"> <col style="mso-width-source:userset;mso-width-alt:804;width:17pt" width="22"> <col style="mso-width-source:userset;mso-width-alt:3730;width:77pt" width="102"> <col style="mso-width-source:userset;mso-width-alt:3913;width:80pt" width="107"> <col style="mso-width-source:userset;mso-width-alt:1097;width:23pt" width="30"> </colgroup><tbody>
</tbody>

High TimedX's
975
#NUM!


<colgroup><col><col></colgroup><tbody>
</tbody>

Formula is returning #NUM =DGET(A7:L11,"NAME",H38:H39)


I am not having any success trying to complete this scoring program.
I am trying to get the "name" of the person with the highest score. The above formula returns the correct name as long as there are no two scores the same.
In the database above, in column High Timed, there are two scores of 97, but the deciding criteria should be the number of X's

Is there a way to write a formula that would return the name of the person with the highest score, taking into account the number of X's.

The correct return in the above case should be "Steve" not "Nathan"

Than you in advance.
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
NameClassLastNew AverageImprove High SlowHigh TimedX's High TimedX's
EdMaster276274-3 84964 975
MarkMaster2762782 90955
SteveMaster2802800 86975 Steve
NathanMaster275271-4 82974

<COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2673" width=75><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2816" width=79><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 98pt; mso-width-source: userset; mso-width-alt: 4636" width=130><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3242" width=91><COL style="WIDTH: 13pt; mso-width-source: userset; mso-width-alt: 597" width=17><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3527" width=99><COL style="WIDTH: 85pt; mso-width-source: userset; mso-width-alt: 4010" width=113><COL style="WIDTH: 48pt" span=3 width=64><COL style="WIDTH: 112pt; mso-width-source: userset; mso-width-alt: 5319" width=150><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3328" width=94><TBODY>
</TBODY>

A:I houses the data; L1:M2 is the area with the criteria.

L4:

=DGET($A$1:$I$5,"NAME",$L$1:$M$2)
 

football

New Member
Joined
Jan 11, 2014
Messages
2
NameClassLastNew AverageImproveHigh SlowHigh TimedX'sHigh TimedX's
EdMaster276274-384964975
MarkMaster276278290955
SteveMaster280280086975Steve
NathanMaster275271-482974

<tbody>
</tbody>

A:I houses the data; L1:M2 is the area with the criteria.

L4:

=DGET($A$1:$I$5,"NAME",$L$1:$M$2)


That works!:)
Thank you for your help
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,315
Members
414,053
Latest member
Dual Showman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top