Spreadsheet: 842502d1694567511-if-and-return-value-based-on-2-sets-of-conditions-sample-2-1
Sheet: Expected Result

NEW - SPONSORSHIPS |  |  |  |  |  |  |  |  |  | NEW - GET NOTICED
Date | Business | MARICOPA | YCO | YUMA | MCO | San Diego | Orange |  |  | Date | Business | MARICOPA | YCO | YUMA | MCO | San Diego | Orange
2023-08-18 00:00:00 | At Your Home Familycare |  |  |  |  | 2200 |  |  | 1 | 2023-08-23 00:00:00 | Gila Cabinet & Stone | 3000
2023-08-22 00:00:00 | Rentals America | 3000 |  |  |  |  |  |  | 2 | 2023-08-23 00:00:00 | OCD Construction | 6000
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  | 15
RENEWAL SPONSORSHIPS |  |  |  |  |  |  |  |  |  | RENEWAL - GET NOTICED
Date | Business | MARICOPA | YCO | YUMA | MCO | San Diego | Orange |  |  | Date | Business | MARICOPA | YCO | YUMA | MCO | San Diego | Orange
2023-08-16 00:00:00 | Umphress Truck N Trailer Repair |  |  | 1000 |  |  |  |  | 1 | 2023-08-17 00:00:00 | Empire Garage Doors |  |  |  |  | 3000
2023-08-17 00:00:00 | MY AUTOMAN | 1500 |  |  |  |  |  |  | 2 | 2023-08-18 00:00:00 | At Your Home Familycare |  |  |  |  | 2200
2023-08-17 00:00:00 | Empire Garage Doors |  |  |  |  | 3000 |  |  | 3 | 2023-08-22 00:00:00 | Rentals America | 3000
2023-08-18 00:00:00 | EZ Flow Plumbing | 4500 |  |  |  |  |  |  | 4 | 2023-08-27 00:00:00 | [NAME] |  |  |  |  | 1500
2023-08-19 00:00:00 | 1st Choice Design & Development |  |  |  |  | 5012 |  |  | 5 | 2023-08-30 00:00:00 | All American Garage Doors |  |  |  |  | 600
2023-08-22 00:00:00 | American Advisors Group |  |  |  |  | 1500 |  |  | 6 | 2023-08-31 00:00:00 | Arizona Foundation Solutions | 1500
2023-08-23 00:00:00 | Gila Cabinet & Stone | 3000 |  |  |  |  |  |  | 7
2023-08-23 00:00:00 | OCD Construction | 6000 |  |  |  |  |  |  | 8
2023-08-24 00:00:00 | True View Windows | 7000 |  |  |  |  |  |  | 9
2023-08-25 00:00:00 | Clean Environment LLC | 3000 |  |  |  |  |  |  | 10
2023-08-25 00:00:00 | Phoenix #1 Automotive LLC | 4000 |  |  |  |  |  |  | 11
2023-08-25 00:00:00 | Be Carb Compliant |  |  |  |  | 2120 |  |  | 12
2023-08-25 00:00:00 | Brothers Home Improvement |  |  |  |  | 3000 |  |  | 13
2023-08-27 00:00:00 | [NAME] |  |  |  |  | 1500 |  |  | 14
2023-08-28 00:00:00 | Absolute Insurance Solutions LLC | 3600 |  |  |  |  |  |  | 15
2023-08-29 00:00:00 | Forefront Roofing |  |  |  |  |  | 4000 |  | 16
2023-08-30 00:00:00 | [NAME] Improvements | 4500 |  |  |  |  |  |  | 17
2023-08-31 00:00:00 | MDTech Services |  |  |  |  |  | 1000 |  | 18
 |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  | 22
ORANGE COUNTY SPLITS
NEW - SPONSORSHIP |  |  |  |  |  |  | Orange |  |  | NEW - GET NOTICED |  |  |  |  |  |  | Orange
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 3
RENEWAL - SPONSORSHIP |  |  |  |  |  |  | Orange |  |  | RENEWAL - GET NOTICED |  |  |  |  |  |  | Orange
 |  |  |  |  |  |  |  |  | 1 | 2023-08-19 00:00:00 | 1st Choice Design & Development |  |  |  |  |  | 5012
 |  |  |  |  |  |  |  |  | 2 | 2023-08-30 00:00:00 | California Solar Installers |  |  |  |  |  | 1500
 |  |  |  |  |  |  |  |  | 3
SPLITS
NEW - SPONSORSHIP |  |  |  |  |  |  |  |  |  | NEW - GET NOTICED
Date | Business | MARICOPA | YCO | YUMA | MCO | San Diego | Orange |  |  | Date | Business | MARICOPA | YCO | YUMA | MCO | San Diego | Orange
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  | 4
RENEWAL - SPONSORSHIP |  |  |  |  |  |  |  |  |  | RENEWAL - GET NOTICED
Date | Business | MARICOPA | YCO | YUMA | MCO | San Diego | Orange |  |  | Date | Business | MARICOPA | YCO | YUMA | MCO | San Diego | Orange
2023-08-29 00:00:00 | Reborn Cabinets |  |  |  |  |  | 1500 |  | 1
2023-08-17 00:00:00 | Sunland Environmental Testing | 3500 |  |  |  |  |  |  | 2
2023-08-29 00:00:00 | Smart Fares |  |  |  |  | 1500 |  |  | 3
 |  |  |  |  |  |  |  |  | 4