Spreadsheet: 57687d1257900773-search-table-with-multiple-criteria-and-return-row-example
Sheet: Deals 1.0

Sold | Delivered | Approved | Booked | Funded | Finalized | Titled | TradePO | SMDealType | Deal# | Customer | Type | Stock# | Status | PL | Year | Model # | Model | SalesPrice | FrontGross | CommGross | BackWeOweSold | BackWeOweCost | Reserve | MBICompany | Warranty | Gap | CreditLife | AH | TotalGross | Bank | SalesMgr | FinanceMgr | Sales1 | Sales1Comm | Sales2 | Sales2Comm | Sales3 | Sales3Comm | DealCount | DC | Back | Sales1CommGross | Sales2CommGross | Sales1BackGross | Sales2BackGross | Sales1FrontGross | Sales2FrontGross
2009-11-02 00:00:00 | 2009-11-02 00:00:00 | 2009-11-02 00:00:00 |  |  |  |  |  | 1   1 | 5424 | HILLIARD,BARBARA J | DEMO | K1009 | P | P | 10 |  | FORT | 13158.02 | -1355.98 | -1759.98 |  |  | 405.22 | [NAME] | 0 | 0 | 0 | 0 | -950.76 | WACH | 9998 | 456 | 9999 | 50 | 9999 | 50
2009-11-03 00:00:00 | 2009-11-03 00:00:00 | 2009-11-03 00:00:00 |  |  |  |  |  | 1   1 | 5434 | YARBROUGH,BOOKER T | USED | U1855 | P | P | 1 | 1WX27 | MONTC | 10863.23 | 1808.23 | 1308.23 |  |  | 0 | CLASSIC AUL | 300 | 0 | 0 | 0 | 2108.23 | ATF | 3719 | 9997 | 7156 | 100 |  |  |  | 0
2009-11-03 00:00:00 | 2009-11-03 00:00:00 | 2009-11-03 00:00:00 | 2009-11-06 00:00:00 |  | 2009-11-06 00:00:00 |  |  | 1   1 | 5435 | COLVIN JR.,ALTHERIA | NEW | N2258 | F | P | 9 | 31422 | RIO | 14322 | -299 | -700 |  |  | 386.57 | [NAME] | 0 | 397 | 0 | 0 | 484.57 | CAP1 | 8801 | 8585 | 7156 | 100 |  | 0 | 0 | 0
2009-11-03 00:00:00 | 2009-11-03 00:00:00 | 2009-11-03 00:00:00 | 2009-11-03 00:00:00 |  | 2009-11-06 00:00:00 |  |  | 2   7 | 5436 | TAYLOR KIA OF BOARDMAN | NEW | N1934 | F | P | 9 | 64222 | SEDONA | 23680 | -300 | -1137 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | -300 | WHL | 9998 | 98 | 9999 | 0 |  |  |  | 0
2009-11-03 00:00:00 | 2009-11-03 00:00:00 | 2009-11-03 00:00:00 | 2009-11-06 00:00:00 |  | 2009-11-06 00:00:00 |  |  | 1   1 | 5440 | NOLA,KAYLA E | NEW | N2172 | F | P | 9 | 31582 | RIO | 14703.06 | -521.94 | -1102.94 |  |  | 609.93 | [NAME] | 0 | 349 | 0 | 0 | 436.99 | FT | 8801 | 8585 | 6928 | 50 | 9773 | 50
2009-11-03 00:00:00 | 2009-11-03 00:00:00 | 2009-11-03 00:00:00 |  |  |  |  |  | 1   1 | 5441 | FREE,CHERYL C | USED | U1836 | P | P | 99 | P53 | TAUR | 5550 | 1057.12 | 557.12 |  |  | 0 | CLASSIC AUL | 200 | 0 | 0 | 0 | 1257.12 | ATF | 3719 | 9997 | 5792 | 50 | 6944 | 50
2009-11-03 00:00:00 | 2009-11-03 00:00:00 | 2009-11-05 00:00:00 |  |  |  |  |  | 1   1 | 5444 | LONGSDORF,JOSHUA G | USED | U1901 | P | P | 8 | KA5L74 | NITRO | 15565 | 1502.97 | 1002.97 |  |  | 589.66 | [NAME] | 0 | 397 | 0 | 0 | 2489.63 | TELCU | 9962 | 8585 | 555 | 0 | 4885 | 0 |  | 0
2009-11-04 00:00:00 | 2009-11-04 00:00:00 | 2009-11-04 00:00:00 |  |  |  |  |  | 1   1 | 5445 | COPELAND,KARMELLA | USED | N2217A | P | P | 0 |  | BEET | 7197.33 | 1553.01 | 1053.01 |  |  | 0 | SERVICE POINT | 100 | 100 | 0 | 0 | 1753.01 | PFS | 3719 | 9997 | 7513 | 100
2009-11-04 00:00:00 | 2009-11-04 00:00:00 |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5446 | CARS UNLIMITED LLC | USED | U1689A | B | P | 99 | RD184 | CRV | 1800 | 400 | 400 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | 400 | WHL | 9998 | 98 | 9999 | 0
2009-11-04 00:00:00 |  |  |  |  |  |  |  | 1 | 5447 | PHILLIPS,VICTOR J | USED | U1661A | P | P | 98 | A51 | WIND | 1587.26 | 467.31 | -32.69 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | 467.31 | CASH | 9962 | 5339 | 6944 | 50 | 37 | 50
2009-11-04 00:00:00 | 2009-11-04 00:00:00 |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5448 | CARS UNLIMITED LLC | USED | N1968B | B | P | 5 | CM5645EW | ACCO | 6500 | 480 | 480 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | 480 | WHL | 9998 | 98 | 9999 | 0
2009-11-04 00:00:00 | 2009-11-04 00:00:00 | 2009-11-04 00:00:00 | 2009-11-06 00:00:00 |  | 2009-11-06 00:00:00 |  |  | 1   1 | 5450 | [NAME],[NAME] | NEW | N2008 | F | P | 9 | 53242 | OPTIMA | 22555.35 | 2553.35 | 1825.35 |  |  | 637.74 | [NAME] | 0 | 397 | 0 | 0 | 3588.09 | KIA | 9962 | 8585 | 9242 | 547.61 |  | 0 | 0 | 0
2009-11-04 00:00:00 | 2009-11-04 00:00:00 | 2009-11-05 00:00:00 |  |  |  |  |  | 1   1 | 5453 | ZAUCHA,JULIE | DEMO | N2156 | P | P | 9 | 53222 | RIO | 18214 | -169 | -850 |  |  | 433.72 | [NAME] | 0 | 0 | 0 | 0 | 264.72 | PSECU | 9962 | 5339 | 555 | 0 | 8134 | 0
2009-11-04 00:00:00 | 2009-11-04 00:00:00 | 2009-11-05 00:00:00 |  |  |  |  |  | 1 | 5455 | TURNEUR,MYRA J | USED | U1840 | P | P | 7 |  | SANTFE | 14375 | 2025 | 1525 |  |  | 587.4 | [NAME] | 911 | 415 | 0 | 0 | 3938.4 | TOWCU | 9962 | 5339 | 555 | 0 | 6944 | 0 |  | 0
2009-11-06 00:00:00 |  |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5467 | PHOENIX AUTO CREDIT | USED | U1517A | B | P | 97 | P13 | ESCO | 400 | -1650 | -2150 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | -1650 | WHL | 9998 | 98 | 9999 | 0 |  |  |  | 0
2009-11-06 00:00:00 | 2009-11-06 00:00:00 |  |  |  |  |  |  | 1   1 | 5468 | MOORE,SHAWN P | USED | N1901B | P | P | 1 | R10 | RANGF | 6983.88 | 1622 | 1122 |  |  | 0 | AUL VINTAGE | 325 | 150 | 0 | 0 | 2097 | ATF | 3719 | 9997 | 9562 | 0 | 1084 | 0 |  | 0
2009-11-06 00:00:00 |  |  |  |  |  |  |  | 1   1 | 5470 | DILLON,TERRANCE K | USED | [NAME] | P | P | 3 |  | RIO | 6900 | 922.07 | 422.07 |  |  |  | WYNN'S | 385 | 0 | 0 | 0 | 1307.07 | CAC | 3719 | 9997 | 4885 | 0 |  |  |  | 0
2009-11-06 00:00:00 | 2009-11-06 00:00:00 | 2009-11-06 00:00:00 |  |  |  |  |  | 1   1 | 5471 | STUMP,[NAME] | USED | N1613A | P | P | 2 | U72 | EXPL | 8079 | 1109 | 609 |  |  | 0 | [NAME] | 0 | 150 | 0 | 0 | 1259 | ATF | 3719 | 9997 | 9242 | 0
2009-11-06 00:00:00 | 2009-11-06 00:00:00 | 2009-11-06 00:00:00 |  |  |  |  |  | 1   1 | 5474 | ROBINSON,[NAME] | NEW | N2245 | P | P | 9 | 31422 | RIO | 15782 | 1441 | 890 |  |  | 1025.64 | [NAME] | 1236 | 0 | 0 | 0 | 3702.64 | CAP1 | 8801 | 710 | 8134 | 0 |  |  |  | 0
2009-11-07 00:00:00 | 2009-11-07 00:00:00 | 2009-11-07 00:00:00 | 2009-11-09 00:00:00 | 2009-11-07 00:00:00 |  |  |  | 1   1 | 5477 | PATRICK,[NAME] | USED | [NAME] | B | P | 99 |  | MIAT | 5894.4 | 229.4 | -270.6 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | 229.4 | CASH | 9962 | 8585 | 6944 | 100 |  |  |  | 0
2009-11-07 00:00:00 | 2009-11-07 00:00:00 | 2009-11-07 00:00:00 |  |  |  |  |  | 1   1 | 5478 | BROWN,[NAME] | USED | U1925A | P | P | 2 | U73 | EXPL | 7900 | 1408.08 | 908.08 |  |  | 0 | WYNN'S VSC | 385 | 0 | 0 | 0 | 1793.08 | CAC | 3719 | 9997 | 1115 | 0
2009-11-07 00:00:00 | 2009-11-07 00:00:00 | 2009-11-07 00:00:00 | 2009-11-09 00:00:00 |  |  |  |  | 1   1 | 5479 | ROE,LEIGH ANN | USED | U1894 | B | P | 6 | P07 | FUSN | 14000 | 1200 | 700 | 0 | 0 | 291.05 | ADVANCE | 0 | 0 | 0 | 0 | 1491.05 | PSECU | 9962 | 710 | 3781 | 87.5 | 6928 | 87.5
2009-11-07 00:00:00 | 2009-11-07 00:00:00 | 2009-11-07 00:00:00 |  |  |  |  |  | 1   1 | 5481 | KINNEY,JANAE | USED | N1481A | P | P | 2 | JRDM41 | STRAD | 6800 | 331.93 | -168.07 |  |  | 0 | WYNN'S | 385 | 0 | 0 | 0 | 716.93 | CAC | 3719 | 9997 | 9304 | 100
2009-11-07 00:00:00 | 2009-11-07 00:00:00 | 2009-11-07 00:00:00 |  |  |  |  |  | 1   1 | 5484 | CARDUCCI,[NAME] | USED | [NAME] | P | P | 3 |  | RIO | 7500 | 4476.07 | 3976.07 |  |  | 0 | WYNN'S | 385 | 0 | 0 | 0 | 4861.07 | CAC | 3719 | 9997 | 6944
2009-11-07 00:00:00 | 2009-11-07 00:00:00 | 2009-11-07 00:00:00 |  |  |  |  |  | 1   1 | 5485 | GILCHRIST,[NAME] | USED | U1808A | P | P | 3 | CE10305 | TRACC | 7575 | 1381.01 | 881.01 |  |  | 0 | VINTGAE AUL | 325 | 0 | 0 | 0 | 1706.01 | ATF | 3719 | 9997 | 7156 | 50 | 8134 | 50
2009-11-09 00:00:00 | 2009-11-09 00:00:00 | 2009-11-09 00:00:00 | 2009-11-09 00:00:00 |  |  |  |  | 2   7 | 5487 | KIA OF ALLIANCE | NEW | N2229 | B | P | 10 | C5462 | FORTE | 16577 | -165 | -795 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | -165 | WHL | 9998 | 98 | 9999 | 0
2009-11-09 00:00:00 | 2009-11-09 00:00:00 | 2009-11-09 00:00:00 | 2009-11-09 00:00:00 |  |  |  |  | 1   1 | 5488 | [NAME],CODY | USED | N2121A | B | P | 95 | 2540 | CAMR | 950 | -550 | -1050 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | -550 | CASH | 8801 | 710 | 9999 | 0
2009-11-09 00:00:00 |  |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5489 | GREATER CLEVELAND AUTO AUCTION | USED | U1897A | B | P | 3 | JRDM41 | STRAD | 1345 | 445 | 445 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | 445 | WHL | 9998 | 98 | 9999 | 0
2009-11-09 00:00:00 |  |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5490 | GREATER CLEVELAND AUTO AUCTION | USED | N1954B | B | P | 99 | 1WL69 | LUMI | 595 | -305 | -305 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | -305 | WHL | 9998 | 98 | 9999 | 0
2009-11-09 00:00:00 |  |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5491 | GREATER CLEVELAND AUTO AUCTION | USED | N1622B | B | P | 96 |  | [NAME] | 195 | -605 | -1105 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | -605 | WHL | 9997 | 98 | 9999 | 0
2009-11-09 00:00:00 |  |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5492 | GREATER CLEVELAND AUTO AUCTION | USED | N2208A | B | P | 1 | PLPH41 | NEONP | 845 | -55 | -55 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | -55 | WHL | 9997 | 98 | 9999 | 0 |  |  |  | 363.1
2009-11-09 00:00:00 | 2009-11-09 00:00:00 | 2009-11-09 00:00:00 | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5493 | GREATER CLEVELAND AUTO AUCTION | USED | U1805A | B | P | 88 | M60 | COUG | 495 | -405 | -405 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | -405 | WHL | 9997 | 98 | 9999 | 0 |  |  |  | 457.9
2009-11-09 00:00:00 |  |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5494 | GREATER CLEVELAND AUTO AUCTION | USED | N1821B | B | P | 99 | 71019 | QX4 | 2945 | 545 | 545 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | 545 | WHL | 9997 | 98 | 9999 | 0
2009-11-09 00:00:00 |  |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5495 | GREATER CLEVELAND AUTO AUCTION | USED | N2247A | B | P | 97 |  | SENTN | 595 | 345 | 345 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | 345 | WHL | 9997 | 98 | 9999 | 0
2009-11-09 00:00:00 |  |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5496 | GREATER CLEVELAND AUTO AUCTION | USED | U1847A | B | P | 92 | 4AG69 | CENT | 345 | -555 | -555 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | -555 | WHL | 9997 | 98 | 9999 | 0
2009-11-09 00:00:00 |  |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5497 | GREATER CLEVELAND AUTO AUCTION | USED | U1831A | B | P | 95 |  | SENTN | 445 | -455 | -455 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | -455 | WHL | 9997 | 98 | 9999 | 0 |  |  |  | 0
2009-11-09 00:00:00 |  |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5498 | GREATER CLEVELAND AUTO AUCTION | USED | N2196A | B | P | 3 | PLDP41 | NEOND | 2695 | 1545 | 1545 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | 1545 | WHL | 9997 | 98 | 9999 | 0
2009-11-09 00:00:00 |  |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5499 | GREATER CLEVELAND AUTO AUCTION | USED | N1843B | B | P | 96 |  | RODE | 1245 | -155 | -155 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | -155 | WHL | 9997 | 98 | 9999 | 0 |  |  |  | 0
2009-11-09 00:00:00 |  |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5500 | GREATER CLEVELAND AUTO AUCTION | USED | U1763A | B | P | 95 | AADH41 | SPIRD | 445 | -355 | -355 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | -355 | WHL | 9997 | 98 | 9999 | 0
2009-11-09 00:00:00 |  |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5501 | GREATER CLEVELAND AUTO AUCTION | USED | N2251A | B | P | 96 | 4AG69 | CENT | 745 | 645 | 645 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | 645 | WHL | 9997 | 98 | 9999 | 0 |  |  |  | 0
2009-11-09 00:00:00 |  |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5503 | GREATER CLEVELAND AUTO AUCTION | USED | U1724A | B | P | 99 | JADH41 | STRAD | 395 | -205 | -205 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | -205 | WHL | 9997 | 98 | 9999 | 0
2009-11-09 00:00:00 |  |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5504 | GREATER CLEVELAND AUTO AUCTION | USED | U1625A | B | P | 3 | 1ND69 | MALIBU | 2445 | -832.68 | -832.68 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | -832.68 | WHL | 9997 | 98 | 9999 | 0 |  |  |  | 0
2009-11-09 00:00:00 |  |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5505 | GREATER CLEVELAND AUTO AUCTION | USED | N2016A | B | P | 96 | P52 | TAUR | 145 | -1055 | -1555 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | -1055 | WHL | 9997 | 98 | 9999 | 0 |  |  |  | 96.52
2009-11-09 00:00:00 |  |  | 2009-11-09 00:00:00 |  |  |  |  | 2   3 | 5506 | GREATER CLEVELAND AUTO AUCTION | USED | N1988A | B | P | 98 |  | DAKO | 530 | -1460 | -1960 |  |  | 0 | [NAME] | 0 | 0 | 0 | 0 | -1460 | WHL | 9997 | 98 | 9999 | 0 |  |  |  | 172.78