tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 437390d1451321187-re-adjusting-rolling-daily-averages-stuck-master-31-day-month
Sheet: Sales & Labor

Monthly Sales w/ Labor and Food Cost %
Only input information in YELLOW cells.
Store Name
 |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  | Week
Date: | 2016-01-01 00:00:00 |  |  |  |  |  |  | Totals |  |  |  |  |  |  |  | Totals |  |  |  |  |  |  |  | Totals |  |  |  |  |  |  |  | Totals |  |  |  | Totals
Voids
Gross Sales
Stuffed Fries
Customer Count
Average Ticket
Coupons
Discounts
Overrings & Drive Offs
Promos & Contest
Fundraisers
Net Sales
Sales Tax
(+) Gift Cards Activate
(-) [NAME] Redeemed
(-) Visa/MC
(-) Amex
(-) Discover
(-) College Card
Total Credit/Debit
(-) Paid outs
Deposit
(=) Over/Short
Crew Hours
Crew Payroll$
Payroll %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last years sales this Month |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Increase/Decrease %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Target Sales (10% increase)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % to Target
Food |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contest/Promos % to Sales
Vendor | Description |  |  | Category (Choose one) |  | Amount |  | Notes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Daily Average
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual Food Cost $$ -From 'COS' Tab in Ideal Food Cost Module
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ideal Food Cost $$ -From 'COS' Tab in Ideal Food Cost Module
 |  |  |  |  |  |  | PO Variance
 |  |  | Paper
Vendor | Description |  |  | Category |  | Amount
All Paid Outs & Expenses
Vendor |  | Description |  |  | Category |  | Amount
Spreadsheet: 771826d1646862837-array-formula-with-sumif-book1
Sheet: Sheet1

Date | Amount | Month |  |  |  | Sumif
2022-01-01 00:00:00 | 1.666666666666667 |  |  |  | 1
2022-02-01 00:00:00 | 1.666666666666667 |  |  |  | 2
2022-03-01 00:00:00 | 1.666666666666667 |  |  |  | 3
2022-04-01 00:00:00 | 1.666666666666667 |  |  |  | 4
2022-05-01 00:00:00 | 1.666666666666667 |  |  |  | 5
2022-06-01 00:00:00 | 2.083333333333333 |  |  |  | 6
2022-07-01 00:00:00 | 2.083333333333333 |  |  |  | 7
2022-08-01 00:00:00 | 2.083333333333333 |  |  |  | 8
2022-09-01 00:00:00 | 2.083333333333333 |  |  |  | 9
2022-10-01 00:00:00 | 2.083333333333333 |  |  |  | 10
2022-11-01 00:00:00 | 2.083333333333333 |  |  |  | 11
2022-12-01 00:00:00 | 2.083333333333333 |  |  |  | 12
2023-01-01 00:00:00 | 2.083333333333333
2023-02-01 00:00:00 | 2.083333333333333
2023-03-01 00:00:00 | 2.083333333333333
2023-04-01 00:00:00 | 2.083333333333333
2023-05-01 00:00:00 | 2.083333333333333
2023-06-01 00:00:00 | 2.083333333333333
2023-07-01 00:00:00 | 2.083333333333333
Spreadsheet: 825361d1681278787-filter-rows-in-power-query-delete-rows
Sheet: Sheet1

Test | Organism
BACTERIA IDENTIFIED - PRELIMINARY | Detected
BACTERIA IDENTIFIED - PRELIMINARY | Cauris
BACTERIA IDENTIFIED - PRELIMINARY | PBAB
BACTERIA IDENTIFIED - FINAL | Not detected
BACTERIA IDENTIFIED - FINAL | CPPA
Fungus | Positive
Fungus | Invalid
Fungus | CRE
MICROORGANISM IDENTIFIED CX NOM (UNSP SPEC) - FINAL | VIM
MICROORGANISM IDENTIFIED CX NOM (UNSP SPEC) - FINAL | Inconclusive
MICROORGANISM IDENTIFIED CX NOM (UNSP SPEC) - FINAL | Detected
MICROORGANISM IDENTIFIED CX NOM (UNSP SPEC) - FINAL | KPC
Spreadsheet: daren_farmer__5994__EI330Breveff061700
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/16/00
Subject:  Revised Availabilities Effective 6/17/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-17 00:00:00 | EI 330 B | 623 | 0 |  |  | 363
1st of month DBQ = 363/d
**Intraday Change**
Increase due to [NAME] plant not being able to process gas.
Spreadsheet: 7304ab99-4ba8-492d-9b4e-d9171efba01c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5930 | 9148 | [NAME] | [NAME] | MEX | 0 | 00:28:36 | 00:03:16 | 01:14:45 | 00:02:00 | 00:53:23 | 1 | 02:42:00
5930 | 17273 | Sergio | Ayala | MEX | 0 | 00:28:38 | 00:03:24 | 01:20:23 | 00:02:12 | 00:51:35 | 2 | [NAME]
5930 | 44866 | Gregory | Estes | MEX | 0 | [NAME] | [NAME] | 01:17:08 | 00:02:33 | 00:58:08 | 3 | 02:54:34
5930 | 44868 | Alfredo | Moreno | MEX | 0 | 00:39:31 | 00:03:29 | 01:23:20 | 00:02:03 | 00:59:05 | 4 | 03:07:28
5930 | 44865 | Armando | [NAME] | MEX | 0 | 00:38:45 | 00:04:44 | 01:27:36 | 00:03:14 | 00:54:32 | 5 | 03:08:51
5930 | 44867 | [NAME] | [NAME] | MEX | 0 | 00:38:00 | 00:04:55 | 01:22:28 | 00:02:27 | 01:03:24 | 6 | 03:11:14
Spreadsheet: 841878d1694009516-bisectional-method-using-recursive-lambda-recursive-bisection-method-lambda-3
Sheet: Test of Bisectional Method 1

Solving the equation 3*X=555 with Bisectional method in normal formulas
Min | [NAME] | Variable | Calculation | Goal | Diff
11 | 500 | 200 |  | 555
Spreadsheet: 132953d1324053349-cannot-get-microsoft-query-to-work-on-excel-files-data-tables
Sheet: Country

Code | Country
1 | Holland
2 | Germany
3 | Switzerland
4 | Finland
5 | Italy
6 | Canada
7 | Panama
8 | Ecuador
9 | Colombia
10 | India
11 | San Salvador
12 | Venezuela
13 | Pakistan
14 | Nicaragua
15 | Texas
16 | Brazil
17 | Bangladesh
18 | Greece
19 | Belgium
20 | England
21 | Australia
22 | New Zealand
23 | Domestic
24 | Costa Rica
25 | Chile
26 | United Arab Emirates
27 | Malaysia
28 | Japan
29 | Denmark
30 | Celebrity
31 | Belize
32 | Austria
33 | Cyprus
34 | Turkey
35 | France
36 | Morrocco
37 | Scotland
38 | Formosa
39 | Slovania
40 | Celebrity Slicing
41 | Portugal
42 | Peru
43 | Philippines
44 | Hong Kong
45 | Uruguay
46 | El Salvador
47 | Puerto Rico
48 | Croatia
49 | Iceland
50 | Indonesia
51 | Estonia
52 | Ireland
53 | Burna Myanmar
54 | Guatemala
55 | Bahamas
56 | Spain
57 | Mexico
58 | Haiti
59 | Korea
60 | Vietnam
61 | Israel
62 | Kuwait
63 | Domestic
64 | Argentina
65 | Florida
66 | Canada
67 | Lithuania
68 | Egypt
69 | [NAME]
70 | Dominican Rep.
71 | Norway
72 | Honduras
73 | Tipico
74 | Poland
75 | Dubon
76 | [NAME]
77 | China
78 | Singapore
79 | East Africa
80 | Taiwan
81 | Sweden
82 | Alaska
83 | Thailand
84 | Hungary
85 | Czech Republic
86 | Yugoslavia
87 | Romania
88 | Mozambique
89 | Burma
90 | South Africa
91 | Jamaica
92 | Bulgaria
93 | Srilanka
94 | Finland None Valio
95 | Russia
96 | Eec/Eu
97
98 | Atalanta Brand
99 | Bolivia
Spreadsheet: 544183d1508790787-duplicate-elimination-example
Sheet: Sheet1

Before 1 |  |  | Before 2 |  |  | After
Customer | Invoice # |  | Customer | Invoice# |  | Customer | Invoice#
[NAME] | 1 |  | [NAME] | 6 |  | [NAME] | 1
[NAME] | 2 |  | [NAME] | 7 |  | [NAME] | 2
[NAME] | 3 |  |  |  |  | [NAME] | 3
[NAME] | 4
[NAME] | 5
Spreadsheet: 122518d1316903989-how-to-interweave-data-in-2-columns-book1
Sheet: Sheet1

2011-01-01 00:00:00 | 0 | 2011-01-03 00:00:00 | 31
2011-01-02 00:00:00 | 0 | 2011-01-04 00:00:00 | 29
2011-01-03 00:00:00 | 31 | 2011-01-05 00:00:00 | 28
2011-01-04 00:00:00 | 29 | 2011-01-06 00:00:00 | 32
2011-01-05 00:00:00 | 28 | 2011-01-07 00:00:00 | 34
2011-01-06 00:00:00 | 32 | 2011-01-10 00:00:00 | 35
2011-01-07 00:00:00 | 34 | 2011-01-11 00:00:00 | 38
2011-01-08 00:00:00 | 0 | 2011-01-12 00:00:00 | 33
2011-01-09 00:00:00 | 0 | 2011-01-13 00:00:00 | 41
2011-01-10 00:00:00 | 35 | 2011-01-14 00:00:00 | 36
2011-01-11 00:00:00 | 38 | 2011-01-18 00:00:00 | 37
2011-01-12 00:00:00 | 33 | 2011-01-19 00:00:00 | 40
2011-01-13 00:00:00 | 41 | 2011-01-20 00:00:00 | 41
2011-01-14 00:00:00 | 36 | 2011-01-21 00:00:00 | 39
2011-01-15 00:00:00 | 0 | 2011-01-24 00:00:00 | 42
Spreadsheet: 681529d1591627388-another-if-s-or-vlookup-equation-request-sample-book-clb
Sheet: Sheet1

Product Code | Item | Per Hour Auto | Per Hour Manual | [NAME] | SNM Manual | Work | Work
 |  |  |  |  |  | Station A | Station B
TOPA1 | Foot Cream 2oz. A | 480 | 240 | 7.5 | 15 | CLBAuto | CLBMan
TOPA2 | Pain Cream 2oz. B | 480 | 240 | 7.5 | 15 | CLBAuto | CLBMan
TOPA3 | Foot Cream 4oz. A | 360 | 180 | 10 | 20 | CLBAuto | CLBMan
TOPA4 | Pain Cream  4oz. B | 360 | 180 | 10 | 20 | CLBAuto | CLBMan
TOPA5 | Juice Balm 4 oz C | 360 | 180 | 10 | 20 | CLBAuto | CLBMan
[NAME] | Juice Balm 1 oz A | 480 | 240 | 7.5 | 15 | CLBAuto | CLBMan
TOPA7 | Balm 1oz  A | 480 | 240 | 7.5 | 15 | CLBAuto | CLBMan
TOPA8 | Balm 1 oz B | 480 | 240 | 7.5 | 15 | CLBAuto | CLBMan
Spreadsheet: 755809d1637103663-extract-multiple-matches-into-separate-rows-but-with-tables-helpme
Sheet: here is formula

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - | - |  |  |  |  |  |  | 4 |  | N | N | N | Y
Spreadsheet: mary_fischer__25740__E-20R
Sheet: E11.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY 20R
COMPANY NAME
ANALYSIS OF OTHER CURRENT LIABILITIES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-11
 |  | 12-31-00 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Revenue accruals for 20R deals |  | 57856312.59 |  |  |  |  |  | -7144810.39
March power revenue accrual |  |  |  |  |  |  |  | -1800000
March gas revenue accrual |  |  |  |  |  |  |  | -4200000
Total Other Current Liabilities
(must tie to Hyperion account 655) | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Income Accts:  DR/(CR)
Reverse signs from Hyperion
Spreadsheet: 17039809-146c-489c-b7db-f288ed23ac78
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FHYDC | Test | FHYDC | Hydroxychloroquine, Serum/Plasma | Hydroxychloroquine | High Performance Liquid Chromatography/Tandem Mass Spectrometry (LC-MS/MS) | Plain, Red-Top Tube: Red OR |  |  | 1 | mL | Submit only 1 of the following specimens:   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not acceptable.)  [NAME] down and send 1 mL of serum refrigerate in plastic vial. Note:  1. Indicate serum on request form.                2. Label specimen appropriately (serum).   [NAME] blood in a purple-top, EDTA tube(s). ([NAME] tube is not acceptable.)  [NAME] down and send 1 mL of EDTA plasma refrigerate in plastic vial. Note:  1. Indicate plasma on request form.                2. Label specimens appropriately (plasma). | 0.4 mL | Specimens other than	Serum, plasma Anticoagulants other than	EDTA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | Reporting limit determined each analysis   Synonym(s): [NAME]; Oxychloroquine   Peak plasma concentrations of 410 +/- 130 ng/mL were achieved 2.4 hours after a single oral dose of 400 mg hydroxychloroquine (n = 6). Two cases of hydroxychloroquine overdose (20 g each) were successfully treated throughout cardiovascular collapse and had serum concentrations of 14000 and 26000 ng/mL.   Test Performed by:  NMS Labs                                        3701 Welsh Road                                        PO Box 433A                                        [NAME], PA  19090-0437 | Wednesday | 1 day | 3-14 days | 1 | 83789 |  |  |  |  | NMS Labs
FHYDC | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 30 days
FHYDC | Result | [NAME] | Hydroxychloroquine | Hydroxychloroquine | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3684-8
FHYDC | Result | Z1864 | Reporting Limit | Reporting Limit | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 0aec4bcf-38b7-4e16-8e9b-3d6e6d14890a
Sheet: Site reports

LITERACY INCENTIVE AID |  |  |  |  | LiteracyIncentiveAid
Minnesota Department of Education |  |  |  |  | 2012-11-14 00:00:00
1 | = District or charter number | Enter the appropriate district and school numbers in the yellow cells.
3 | = School number | District and charter names and numbers can be found in the Names tab. |  |  |  |  |  |  | Lookup:
 |  | For Minneapolis, enter district = 1.2. |  |  |  |  |  |  | Listed site?
 |  | Almost every charter school has school number = 10. |  |  |  |  |  |  | Any filters?
 |  | FY 2010 | FY 2011 | FY 2012 | Total
 | MCA Proficiency Counts
1 | Total grade 3 reading scores
 | Total scores in the proficient range
 |  | n/a | n/a | n/a
 | Grade 3 enrollment as of October 2011 | n/a | n/a | n/a
 |  | n/a | n/a | n/a
 | Growth [NAME]
 | Total grade 4 reading growth results
 | Total with high or medium growth
 |  | n/a | n/a | n/a
 | Grade 4 enrollment as of October 2011 | n/a | n/a | n/a
 |  | n/a | n/a | n/a
 |  | n/a | n/a | n/a
 | Proration rate (approximate) | n/a | n/a | n/a | 0.9557797607639166
 |  | n/a | n/a | n/a
Notes:
Literacy incentive aid goes into effect in FY 2013, based on legislation passed in 2011 and amended in 2012.
For FY 2013 only, the state total aid entitlement is capped at $48,585,000.
Aid is based on grade reading 3 proficiency and grade 4 reading growth, based on the prior 3 years'
administrations of the Minnesota Comprehensive Assessment (MCA).  The calculation is done separately
for each building.
Test counts are shown as "Filtered" if any of a site's total test counts, as shown in lines 1 and 7, have been
filtered because at least one total is between 1 and 9.
Please direct questions to [NAME] at either [PHONE] or [EMAIL].
1 | Does Not Meet Standards
 | Partially Meets Standards
 | Meets Standards
 | Exceeds Standards
 | Low proficiency, high growth
 | Low proficiency, medium growth
 | Low proficiency, low growth
 | High proficiency, high growth
 | High proficiency, medium growth
 | High proficiency, low growth
Spreadsheet: benjamin_rogers__1049__Consolidated 6 Peaker-051800-PE
Sheet: Assumptions

ASSUMPTIONS
TECHNICAL ASSUMPTIONS: |  | 1999 PROJECTS |  |  |  | 2000 PROJECTS
 |  | Brownsville | Caledonia | New Albany |  | [NAME] | Wheatland | [NAME] |  | Sub Total
Number of Turbines |  | 4 | 6 | 6 |  | 3 | 4 | 8
Summer Capacity (MW)(1) |  | 458 | 466 | 371 |  | 510 | 470 | 608
[NAME] (HHV, Btu/kWh) |  | 11406 | 12064 | 12500 |  | 10592 | 11734 | 11973
Numbers of Starts |  | 75 | 75 | 75 |  | 75 | 75 | 75
PRICING ASSUMPTIONS:
Fixed Price Demand Charge ($/kW-month) |  | 4
Energy Charge ($/MWh)
Start Charge ($/Start/Turbine)
Annual Generation (MWh) |  | 624921.7078730493 | 544139.6717506632 | 410269.84 |  | 532991.6197855896 | 461312.7218562186 | 2002000
OPERATING COSTS ASSUMPTIONS:
Variable O&M ($/MWh-year) |  | 1.5 | 1 | 1 |  | 1.5 | 3 | 2
Major [NAME] ($/Start/Turbine) |  | 1500 | 1000 | 1000 |  | 1500 | 1500 | 1000
Annual Escalator |  | 0.03
Annual Cost (000$ in Year 2000)
Fixed O&M |  | 1563.63147 | 1721.30196 | 1878.06659 |  | 1242.481714285714 | 1515.790285714286 | 1448.540571428571
Variable O&M
Major [NAME]
O&M Management Fee |  | 0 | 0 | 0 |  | 0 | 0 | 0
Owner's Expense |  | 431.7851666666667 | 410.9306666666667 | 362.6721666666667 |  | 322.2511428571429 | 306.2677142857142 | 400.6471428571429
Property Taxes Liability
TAX ASSUMPTIONS:
Federal Income Tax Rate |  | 0.35 | 0.35 | 0.35 |  | 0.35 | 0.35 | 0.35 |  | 0.35
State Income Tax Rate |  | 0.06 | 0.05 | 0.05 |  | 0.06 | 0.045 | 0.0718
Adjusted Gross Income Tax |  | N/A | N/A | N/A |  | N/A | 0.034 | N/A
Gross Receipts Tax Rate |  | N/A | N/A | N/A |  | N/A | 0.012 | N/A
Franchise Tax Rate (Year 1) |  | 0.0025 | 0.0025 | 0.0025 |  | 0.0025 | N/A | 0.0015
Franchise Tax Rate (Year 2-20) |  | 0.0025 | 0.0025 | 0.0025 |  | 0.0025 | N/A | 0.001
(1) Includes additional capacity of 20 MW at Caledonia and 15 MW at New Albany, with installation of evaporative coolers by June 2000.
Spreadsheet: 845334d1696864207-filter-by-column-and-by-row-competence-matrix-filter-updated1
Sheet: Sheet1

Name/skill | Finance | Manufacturing | Supply chain | Developer |  |  | FILTER |  | FILTER |  | Result
Marian | C | C | X | C
George |  | X | X | C |  |  | Finance | True | X | False | Radu
Alina | X |  | X | C |  |  | Manufacturing | False | C | True | Cristian
Radu |  |  | C | C |  |  | Supply chain | True
Cristian |  | X | C | C |  |  | Developer | False
Spreadsheet: 730690d1619849383-formulas-with-multiple-range-criteria-not-returning-result-sample
Sheet: Sript Entry

Order No. | Order Time | Trade No. | Trade Time | Security/ Contract description | [NAME] ( B/S ) | Quantity | Gross Rate/ Trade Price Per Unit (Rs) | Brokerage Per unit (Rs) | Net Rate Per unit (Rs) | Closing Rate Per unit only Der.(Rs) | Net Total (Before Levies) (Rs) |  | Required as follows.
 |  |  |  |  |  |  |  |  |  |  |  |  | OPTIDX BANKNIFTY 08 APR 2021 30000 PUT
 |  |  |  |  |  |  |  |  |  |  |  |  | OPTIDX BANKNIFTY 08 APR 2021 31000 PUT
Spreadsheet: 683647d1592863506-formula-that-returns-a-value-under-specific-conditions-region-issuev3
Sheet: Sheet1

Entered Account # | Entered Date | Region (as returned from formula) |  |  |  |  | [NAME] that Returns a Value under Specific Conditions
ABC | 2018-02-01 00:00:00 |  |  |  |  |  | My problem is as below: I have some data that was dumped from a database and I need to return the "Region" from that data (for the "Entered Account #" and "Entered Date") under the following conditions: - IF "Void?" = "Y", THEN STOP, no need to look further.  But if record NOT voided, then: 1.  IF "Span Duration is = 365 or 366 and  2.  "Entered Date" is >= the "From Date" and  3.  "Entered Date" is <= the "To Date"THEN return "Region" from the "matched" row.  BUT only perform steps 1-3 when the "Entered Account #" is = the "Account #" from the Database Data.  Need to check all the date spans within that "Account #". That's Part 1. Part 2 is:  IF "Void?" is <> "Y" and "Span Duration" is < 365, THEN use the "Region" from the next row in the database data but ONLY if that next row is for the same "Account #"   I tried using all kinds of combinations of INDIRECT, ADDRESS, CELL, COLUMN, ROW, iNDEX and am not having any luck.   I can't use a macro for this and was wondering if it is able to be done with a formula. I'm probably/definitely biting off more than I can chew :) but any help you can provide will be hugely appreciated.  Thanks!
ABC | 2020-03-01 00:00:00
ABC | 2020-02-01 00:00:00 | Voided Record
DEF | 2018-06-30 00:00:00
ABC | 2019-02-01 00:00:00
DEF | 2019-02-01 00:00:00 | Voided Record
DEF | 2017-01-01 00:00:00
DEF | 2019-02-01 00:00:00
Database Data
Account # | Void? | Span Duration (Days) | From Date | To Date | Region
ABC | N |  | 2018-01-01 00:00:00 | 2018-12-31 00:00:00 | Boston
ABC | N |  | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | New York
ABC | N |  | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | Sacramento
ABC | Y |  | 2018-02-01 00:00:00 | 2018-01-01 00:00:00 | Tulsa
DEF | N |  | 2018-01-01 00:00:00 | 2018-12-31 00:00:00 | Wichita
DEF | N |  | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | Sarasota
DEF | Y |  | 2018-02-01 00:00:00 | 2018-01-01 00:00:00 | Reno
DEF | N |  | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | Denver
So sorry I was not clear….It means if there is a "Y" in the "Void?" column, that means the record is a voided record and no need to do steps 1, 2, and 3, i.e., you don't need to check the "Span Duration" or if the "Entered Date" falls between the "From Date" and "Date".  Basically, just return a value that says "Voided Record"
So to the differences between your results and mine, in rows 7 and 9:
For Row 7:  You are right….it should return Sarasota
For Row 9:  When you look at the Account # and Date in Row 9, the formula should look in the DEF records, and it finds that the "Entered Date" of 1-Feb-19 falls into the the range shown in row 18...so the value returned should also be "Region" Sarasota, the region on row 18
Spreadsheet: 719896d1613892970-placing-1-of-24-outcomes-based-on-drop-downs-with-three-options-pq-isolation-selection-tool-aligw
Sheet: Selection Tool

MINIMUM PROCESS ISOLATION STANDARD SELECTION TOOL
Substance Category |  | [NAME] ([NAME]) |  |  | Intrusive Work
1 |  | <50 |  |  | NO
Minimum Isolation Standard (If not practicable to achieve a positive Isolation)
Minimum Isolation Standard Description
V | Valve configuration required to permit the installation of blank flanges, spaded or for air gapping.
I | Valve configuration required to permit carrying out intrusive maintenance without a positive isolation.
DBB | Double Block & Bleed
SBB | Single Block & Bleed
SVI | Single Valve Isolation
Spreadsheet: darrell_schoolcraft__7477__imball0202
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -47885 | -21618
9238 | -11483 | -11000 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 |  | -897976
58710 | -4936 | -31148
60921 | -832321 | -964968
78026 |  | 6050
500084 | -25859 | -33000
500085 | -3589
500097 | -39982 | -44000
INDEX
2002-01-31 00:00:00 |  |  | 835344.24
2002-02-11 00:00:00
CBS Volume
 |  |  | 340221
Spreadsheet: daren_farmer__6613__Guest List
Sheet: JULY

 |  | 2000  Gas Logistics' Guest List
 | Customers |  | Schedulers |  | Admins & Management (x2)
1 | [NAME] – CIG | 1 | Briant [NAME] | 1 | Heather Choate
2 | [NAME] – El Paso | 2 | [NAME] | 2 | Chantelle Villarreal
3 | [NAME] | 3 | [NAME] | 3 | [NAME]
4 | [NAME] – PGT | 4 | [NAME] | 4 | [NAME]
5 | [NAME] – TW | 5 | [NAME] | 5 | [NAME]
6 | [NAME] – Texas Eastern | 6 | [NAME] | 6 | [NAME]
7 | [NAME] Gulf Trans. | 7 | [NAME] | 7 | [NAME]
8 | [NAME] Gas | 8 | [NAME] | 8 | [NAME]
9 | [NAME] | 9 | Beverly Beaty | 9 | [NAME]
10 | [NAME] | 10 | [NAME] | 9 (18) | TOTAL
11 | [NAME] | 11 | [NAME]
12 | [NAME] | 12 | [NAME] | 130 Total Attendees
13 | [NAME] | 13 | [NAME]
14 | Tonia [NAME] | 14 | [NAME]
15 | [NAME] | 15 | Meredith Mitchell
16 | [NAME] | 16 | Cindy Vachuska
17 | [NAME] | 17 | [NAME]
18 | [NAME] – Reliant | 18 | [NAME]
19 | [NAME] | 19 | [NAME]
20 | [NAME] Border | 20 | [NAME]
21 | [NAME] | 21 | [NAME]
22 | [NAME] Gas | 22 | [NAME]
23 | [NAME] | 23 | [NAME]
24 | [NAME] | 24 | [NAME]
25 | [NAME] | 25 | [NAME]
26 | [NAME] Energy | 26 | [NAME]
27 | [NAME] | 27 | [NAME]
28 | Sheree [NAME] Services | 28 | [NAME]
29 | [NAME] | 29 | [NAME]
30 | Vince  Romeo – PG&E | 30 | [NAME]
31 | [NAME] | 31 | [NAME]
32 | [NAME] | 32 | Margie Straight
33 | [NAME] | 33 | [NAME]
34 | [NAME] | 34 | [NAME]
35 | [NAME] Energy | 35 | [NAME]
36 | [NAME] | 36 | [NAME]
37 | [NAME] Gas Transmission | 37 | [NAME]
38 | [NAME] Gas | 38 | Morgan Sharifi
39 | [NAME] | 39 | [NAME]
40 | [NAME] | 40 | [NAME]
41 | [NAME] Energy | 41 | [NAME]
42 | [NAME] | 42 | [NAME]
43 | [NAME] | 43 | [NAME]
44 | Marquette Evans - Natural Gas Pipeline | 44 | [NAME]
45 | [NAME] Natural Gas | 45 | [NAME]
46 | [NAME] | 46 | [NAME]
47 | [NAME] | 47 | Stella Morris
48 | [NAME] | 48 | [NAME]
49 | HPL - Guest to be named | 49 | [NAME]
50 | HPL - Guest to be named | 50 | [NAME]
51 | HPL - Guest to be named | 51 | [NAME]
52 | HPL - Guest to be named | 52 | [NAME]
53 | HPL - Guest to be named | 53 | [NAME]
54 | HPL - Guest to be named | 53 | TOTAL
55 | HPL - Guest to be named
56 | HPL - Guest to be named
57 | HPL - Guest to be named
58 | HPL - Guest to be named
59 | HPL - Guest to be named
59 | TOTAL