Spreadsheet: 782778d1654266521-need-to-bring-in-max-amount-based-on-multiple-criteria-query-3
Sheet: Sheet1

Name | Data Name | ID | $ |  | MAX |  |  |  |  | Data | [NAME] |  | Desired |  |  | Data Name | Corrected Data Name
[NAME] | The Bird Perch - Ashville | 10001 | 2112 |  | Need Value: 2993 (D25+D26) |  |  |  |  | Bird Perch | 2993 |  |  |  |  | The Bird Perch - Ashville | The Bird Perch
Charlotte | Brightmore | 10002 | 188 |  |  |  |  |  |  | Brightmore | 2156 |  |  |  |  | Brightmore | Brightmore
Charlotte | Brightmore | 10002 | 226 |  |  |  |  |  |  | CP Grand | 139 |  |  |  |  | CP Grand | CP Grand
Charlotte | Brightmore | 10002 | 1263 |  |  |  |  |  |  | [NAME] | 1291 |  | This is the MAX amount between both ranges with [NAME] as "Data Name" other set = $845 |  |  | [NAME] | [NAME]
Charlotte | Brightmore | 10002 | 479 |  |  |  |  |  |  | etc… | etc… |  |  |  |  | Warhorse | Warhorse
WB | CP Grand | 10003 | 139 |  |  |  |  |  |  |  |  |  |  |  |  | 23782 - Warhorse - Colorado | Warhorse
LD | [NAME] | 10004 | 605 |  |  |  |  |  |  |  |  |  |  |  |  | Warhorse - Omaha | Warhorse
LD | [NAME] | 10004 | 284 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
LD | [NAME] | 10004 | 402 |  |  |  |  |  |  |  |  |  |  |  |  | Underground ATL Food Hall | Underground ATL Food Hall
GB | Warhorse | 10005 | 1680 |  |  |  |  |  |  |  |  |  |  |  |  | The Reston | Reston
GB | Warhorse | 10005 | 1480 |  |  |  |  |  |  |  |  |  |  |  |  | Reston | Reston
GB | Warhorse | 10005 | 339 |  |  |  |  |  |  |  |  |  |  |  |  | KC Braces | KC Braces
GB | Warhorse | 10005 | 2925 |  |  |  |  |  |  |  |  |  |  |  |  | The Bird Perch | The Bird Perch
GB | 23782 - Warhorse - Colorado | 10006 | 665 |  |  |  |  |  |  |  |  |  |  |  |  | Riverside Country Club | Riverside Country Club
GB | Warhorse - Omaha | 10007 | 420 |  |  |  |  |  |  |  |  |  |  |  |  | Riverside Golf Club | Riverside Country Club
GB | [NAME] | 10008 | 52 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
GB | [NAME] | 10008 | 121 |  |  |  |  |  |  |  |  |  |  |  |  | Sal's Pizza | Sal's Pizza
GB | [NAME] | 10008 | 672 |  |  |  |  |  |  |  |  |  |  |  |  | Children's Museum Bloom | Children's Museum Bloom
SHEP | [NAME] | 10009 | 1150 |  |  |  |  |  |  |  |  |  |  |  |  | Alta Naco | Alta Naco
REX | Underground ATL Food Hall | 10010 | 1008 |  |  |  |  |  |  |  |  |  |  |  |  | LD-1111 Alta Naco | Alta Naco
DUL | The Reston | 10011 | 2048 |  |  |  |  |  |  |  |  |  |  |  |  | 1299 N. California - 61796 | N. California
GB | Reston | 10012 | 2048 |  |  |  |  |  |  |  |  |  |  |  |  | 1300 N. California - 61796 | N. California
EE | KC Braces | 10013 | 0 |  |  |  | Need Value: $840 |  |  |  |  |  |  |  |  | 1301 N. California - 61796 | N. California
Charlotte | The Bird Perch | 10014 | 545 |  |  |  |  |  |  |  |  |  |  |  |  | Canopy [NAME] | Reston
Charlotte | The Bird Perch | 10014 | 2448
STEIN | Riverside Country Club | 10015 | 105
[NAME] | Riverside Golf Club | 10016 | 840
NCG | [NAME] | 10017 | 130
NCG | [NAME] | 10017 | 323
NCG | [NAME] | 10017 | 406 |  | Need Value: SUM(D34:D37)
Crawfish | Sal's Pizza | 10018 | 435
REX | Children's Museum Bloom | 10019 | 336
LD | Alta Naco | 10020 | 944
LD | Alta Naco | 10020 | 548
LD | Alta Naco | 10020 | 408
LD | Alta Naco | 10020 | 952
TF | LD-1111 Alta Naco | 10021 | 945
TF | LD-1111 Alta Naco | 10021 | 634
KINGS | 1299 N. California - 61796 | 10022 | 162
KINGS | 1300 N. California - 61796 | 10022 | 145
KINGS | 1301 N. California - 61796 | 10022 | 135
gTF | Canopy [NAME] | 10023 | 2049 |  |  |  | Need Value: 2049