tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 722002d1614980830-what-formula-would-return-2-results-horizontally-and-vertically-get-matrix-headers-v2-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | the list
 |  |  |  |  |  |  |  |  | choose | result |  |  |  |  | HAM-001
 |  | Level | D18 | D17 | D16 | D15 | D14 |  | OXF-145 |  |  |  |  |  | HAM-002
 |  | G | OXF-145 |  |  |  |  |  |  |  |  |  |  |  | HAM-003
 |  | F |  |  |  |  |  |  |  |  |  |  |  |  | HAM-028
 |  | E |  |  |  | HAM-43 | HAM-428 |  |  |  |  | Explanation |  |  | HAM-029
 |  | D | OXF-002 | OXF-003 | HAM-039 | HAM-031 | OXF-145 |  |  |  |  |  |  |  | HAM-031
 |  | C | OXF-163 | OXF-203 | HAM-001 | HAM-029 | OXF-422 |  |  |  |  |  |  |  | HAM-039
 |  | B | HAM-203 | HAM-164 | OXF-145 | HAM-028 | HAM-422 |  |  |  |  |  |  |  | [NAME]
 |  | A | [NAME] | HAM-164 | [NAME] | HAM-039 | HAM-002 |  |  |  |  |  |  |  | HAM-164
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HAM-203
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HAM-422
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HAM-428
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HAM-43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OXF-002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OXF-003
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OXF-145
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OXF-163
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OXF-203
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OXF-422
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BVJ-007
Spreadsheet: 71468d1272204053-formula-dropdown-new-microsoft-office-excel-worksheet
Sheet: Sheet1

2010-04-24 00:00:00 |  | 2010-04-25 00:00:00
LLLL | OOOO | LLLL
MMM | PPPP | MMM
NNN | QQQQ | NNN
 |  | AAAA
2010-04-25 00:00:00 |  | EEEE
LLLL | OOOO | OOOO
MMM | PPPP | PPPP
NNN | QQQQ | QQQQ
AAAA | BBBB | BBBB
EEEE | FFFF | FFFF
2010-04-26 00:00:00
LLLL | OOOO
MMM | PPPP
NNN | QQQQ
CCCC | DDDD
Spreadsheet: 453763d1459436222-can-i-use-vlookup-to-do-this-sample-file
Sheet: Result

ID | Company | Quarter | Amount
1 | Google | Q1 | 1000
1 | Google | Q2 | 2000
1 | Google | Q3 | 3000
1 | Google | Q4 | 4000
2 | Yahoo | Q1 | 1000
2 | Yahoo | Q2 | 2000
2 | Yahoo | Q3 | 3000
2 | Yahoo | Q4 | 4000
3 | AOL | Q1 | 1000
3 | AOL | Q2 | 2000
3 | AOL | Q3 | 3000
3 | AOL | Q4 | 4000
4 | Microsoft | Q1 | 1000
4 | Microsoft | Q2 | 2000
4 | Microsoft | Q3 | 3000
4 | Microsoft | Q4 | 4000
5 | Sony | Q1 | 1000
5 | Sony | Q2 | 2000
5 | Sony | Q3 | 3000
5 | Sony | Q4 | 4000
Spreadsheet: 121905d1316504529-excel-2007-behavior-data-792896
Sheet: Sheet1

Row Labels | Count of Behavior
Not Indicated | 2
Student 3 | 1
Matrix C - Sexual Harassment | 1
Student 6 | 1
Matrix B - Posession of stolen prop. | 1
2011-09-01 00:00:00 | 3
Student 4 | 1
Matrix B - Noncompliance/staff | 1
Student 5 | 1
Matrix B - Vandalism | 1
Student 9 | 1
Matrix B - Vandalism | 1
2011-09-09 00:00:00 | 6
Student 3 | 2
Matrix B - Bullying /student | 1
Matrix B - minor vandalism | 1
Student 6 | 2
Matrix B - Disrespect | 1
Matrix B - Minor theft | 1
Student 7 | 1
Matrix B - Disrespect/name call | 1
Student 8 | 1
Matrix B - Bullying | 1
2011-09-15 00:00:00 | 2
Student 1 | 1
Matrix B - verbal harass/language | 1
Student 2 | 1
Matrix B - Physical Harassment | 1
Grand Total | 13
Spreadsheet: 121010d1315765389-setting-up-a-project-point-sheet
Sheet: Summary

 | September
Trustworthiness
Altering the planner | 1
Cheating | 0
Honesty
Lying | 5
Caring
Uninvited Comment | 0
Instigating | 0
Respect
Insubordination | 0
Arguing | 2
Failure to Stop | 5
Interrupting Lesson | 0
Disrespect | 0
Citizenship
Hallway | 3
Dress Code | 0
Sleeping or [NAME] | 0
Gum | 0
Electronics Out | 0
Poor Choice | 0
Swearing | 0
Responsibility
Not Prepared | 2
[NAME] | 0
Failure to follow Directions | 0
Other Behavior
Phone Call | 0
One Hour Detention | 0
One Hour Isolation | 0
In School Suspension | 0
Out of School Suspension | 0
Total Points for the Month | 18
Spreadsheet: 130609d1322487432-linking-formula-for-two-spreadsheets-a
Sheet: Sheet1

 |  | CURRENT STATE OF DATA
 |  | LABEL | x | y
 |  | 1 | 5.60999 | -0.21147
 |  | 2 | 5.61 | -0.21146
 |  | 3 | 5.60985 | -0.21164
 |  | 4 | 5.60972 | -0.21178
 |  | 5 | 5.60951 | -0.21212
 |  | 6 | 5.60937 | -0.21236
 |  | 7 | 5.60915 | -0.21266
 |  | 8 | 5.6089 | -0.21303
 |  | 9 | 5.6087 | -0.21332
 |  | 10 | 5.60848 | -0.21363
Spreadsheet: 1a64270d-d733-4cff-9e61-00407b6535d8
Sheet: Sheet1

To Calculate the costs for an IPA proposal with an industrail contribution of 10%
Please use the appropriate calculator depending on the value you already know.
Please fill in the orange box, The other values will be shown in the green boxes
 | To Calculate the Industrial Contribution of 10%  and the fEC requested from BBSRC if the total project cost is known
 | Total project cost (inc industrial contribution) | fEC requested from BBSRC | Industrial contribution of 10%
 | 0
 | To Calculate the Total project costs and FEC from BBSRC if the industrial contribution of 10% is known.
 | Total project cost (inc industrial contribution) | fEC requested from BBSRC | Industrial contribution of 10%
 |  |  | 0
 | To calculate the Total project cost and the industrial contribution of 10% if the fEC from BBSRC is known
 | Total project cost (inc industrial contribution) | fEC requested from BBSRC | Industrial contribution of 10%
 |  | 0
Please note:
The industrial contribution for an IPA is 10% of the total project costs, not 10% of the fEC requested from BBSRC.
The amount requested from BBSRC is the amount that goes in the Je-S form in the fEC boxes
The industrial contribution is put on the Je-S form using the 'project partners' box
If the industrial contribution is >10% these calculations will no longer be accurate.
Spreadsheet: 36fbd09d-da96-4e76-b116-97a23e148fec
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
GRW | Test | GRW | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. - 8 p.m., Saturday; 8 a.m. - 3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
GRW | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
GRW | Result | GRW | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6124-2 | Ambrosia [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 7303cab3-80a9-479b-985f-16066a9d12b2
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42222962 | 2014-07-09 04:32:16 | ALLIES | 1 | 6 | 1 | 1586551 | stephane.boivin | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42223189 | 2014-07-09 04:51:50 | AXIS | 0 | 5 | 6 | 1586551 | stephane.boivin | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
Spreadsheet: 760140d1640018841-randomizing-pairs-from-odd-or-even-list-rand_pairings
Sheet: Sheet1

 | Even # Participants |  | Pairings
1 | Fred | 1 |  |  |  | George | Barney
2 | Barney | 2 |  |  |  | Fred | Snoopy
3 | George | 3 |  |  |  | [NAME] | Elroy
4 | Elroy | 4 |  |  |  | Schroeder | Linus
5 | [NAME]
6 | Linus
7 | Schroeder
8 | Snoopy
 | Odd # Participants |  | Pairings
1 | Wilma | 1 |  |  |  | [NAME] | [NAME]
2 | Betty | 2 |  |  |  | #REF | Velma
3 | [NAME] | 3 |  |  |  | Daphney | Veronica
4 | [NAME] | 4 |  |  |  | [NAME] | Betty
5 | Veronica | 5 |  |  |  | [NAME] | Wilma
6 | [NAME]
7 | [NAME]
8 | Velma
9 | [NAME]
Spreadsheet: 89608d1289390043-expand-a-column-using-linear-interpolation-linear_interpolation
Sheet: Sheet1

2048
2096
2144
2192
2240
2288
2336
2384
2432
2480
2528
2576
Spreadsheet: 749124d1632515449-extract-data-from-sheet-to-another-sheet-based-on-selected-month-trial-version-tms
Sheet: List1

Name | Last name | Address | Adress | arival | departure | Month
[NAME] | Votípková | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Petrq | Votípka | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
[NAME] | Kroupa | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Pavla | Kroupová | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Zuzana | Kroupová | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
[NAME] | Kroupová | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
[NAME] | Votípková | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Jan | Votípka | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
t | t | test | test | 2021-08-20 00:00:00 | 2021-08-22 00:00:00
Štěpánka | [NAME] | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Martin | Král | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Eliška | Králová | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Adam | Král | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Šárka | Krocová | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Vladimír | Kroc | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Vladimír | Kroc | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Valeria | Krocová | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Eva | Kuběnová | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Zdeněk | Kuběna | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
[NAME] | Kuběna | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Elena | Kuběnová | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
test | test | test | test | 2021-09-17 00:00:00 | 2021-09-19 00:00:00
test | test | test | test | 2021-09-17 00:00:00 | 2021-09-19 00:00:00
test | test | test | test | 2021-06-23 00:00:00 | 2021-06-30 00:00:00
test | test | test | test | 2021-01-22 00:00:00 | 2021-01-25 00:00:00
test | test | test | test | 2021-01-22 00:00:00 | 2021-01-25 00:00:00
test | test | test | test | 2021-01-22 00:00:00 | 2021-01-25 00:00:00
test | test | test | test | 2021-01-22 00:00:00 | 2021-01-25 00:00:00
test | test | test | test | 2021-01-22 00:00:00 | 2021-01-25 00:00:00
test | test | test | test | 2021-01-22 00:00:00 | 2021-01-25 00:00:00
test | test | test | test | 2021-01-22 00:00:00 | 2021-01-25 00:00:00
test | test | test | test | 2021-02-04 00:00:00 | 2021-02-10 00:00:00
test | test | test | test | 2021-02-04 00:00:00 | 2021-02-10 00:00:00
Spreadsheet: 680513d1591066905-is-it-possible-to-use-imported-queries-in-normal-formula-bar-without-load-to-worksheet-ef-master
Sheet: KoefAHSP

NOMOR KOEFISIEN | [NAME] | SATUAN | GLOBAL OVERHEAD | SUMBER | COUNT ITEM | COUNT MTRL | COUNT UPAH | COUNT ALAT | COUNT SUBKON2 |  |  | GLOBAL OVERHEAD | 10.00%
A.2.2.1.1 | (K3) PEMBUATAN 1 M2 PAGAR SEMENTARA DARI KAYU TINGGI 2 METER | M2 |  | PERMEN PUPR 28/PRT/M/2016
A.2.2.1.2 | (K3) PEMBUATAN 1 M2 PAGAR SEMENTARA DARI SENG GELOMBANG TINGGI 2 METER | M2 |  | PERMEN PUPR 28/PRT/M/2016
A.2.2.1.3 | (K3) PEMBUATAN 1 M2 PAGAR SEMENTARA DARI KAWAT DURI TINGGI 1.8 METER | M2 |  | PERMEN PUPR 28/PRT/M/2016
Spreadsheet: 5ecca90d-c468-4ef6-94d2-c55345b04032
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
Table S6:  Lung cancer mortality rates (per 100,000) among Asian male lifelong never smokers in individual cohort studies
 |  | Cohort
 |  | [NAME] |  | [NAME] |  | KCPS |  |  |  | MEC |  |  |  | Three Prefectures
Follow-up |  | 1966-82 |  | 1988-90 |  | 1992-2004 |  |  |  | 1993-2003 |  |  |  | 1983-
 |  | Rate |  | Rate |  | Deaths | PY | Rate (95% CI)† |  | Deaths | PY | Rate (95% CI)† |  | Deaths | PY | Rate (95% CI)†
Age
25-29 |  | - |  | - |  | 0 | 0 | - |  | 0 | 0 | - |  | 0 | 0 | -
30-34 |  | - |  | - |  | 0 | 67279 | 0.0 ( 0.0, 0.0) |  | 0 | 0 | - |  | 0 | 0 | -
35-39 |  | - |  | - |  | 3 | 231218 | 1.3 (0.3, 3.8) |  | 0 | 0 | - |  | 0 | 0 | -
40-44 |  | 4.5 |  | 14.6 |  | 8 | 354326 | 2.3 (1.0, 4.4) |  | 0 | 0 | - |  | 1 | 3593 | 27.8 (0.7, 155.1)
45-49 |  | 7.6 |  |  |  | 22 | 340900 | 6.5 ( 3.8, 9.2) |  | 0 | 4304 | 0.0 ( 0.0, 0.0) |  | 1 | 10591 | 9.4 (0.2, 52.6)
50-54 |  | 4.9 |  | 26.8 |  | 30 | 302462 | 9.9 ( 6.4, 13.5) |  | 1 | 10372 | 9.6 (0.2, 53.7) |  | 2 | 13627 | 14.7 (1.8, 53.0)
55-59 |  | 10.6 |  |  |  | 57 | 296976 | 19.2 ( 14.2, 24.2) |  | 1 | 9892 | 10.1 (0.3, 56.3) |  | 1 | 11965 | 8.4 (0.2, 46.6)
60-64 |  | 18.4 |  | 61.5 |  | 74 | 253812 | 29.2 ( 22.5, 35.8) |  | 0 | 8864 | 0.0 ( 0.0, 0.0) |  | 4 | 8258 | 48.4 (13.2, 124.0)
65-69 |  | 28.2 |  |  |  | 92 | 161685 | 56.9 ( 45.3, 68.5) |  | 1 | 10219 | 9.8 (0.2, 54.5) |  | 1 | 5268 | 19.0 (0.5, 105.8)
70-74 |  | 33.1 |  | 109.1 |  | 72 | 74632 | 96.5 ( 74.2, 118.8) |  | 4 | 11827 | 33.8 (9.2, 86.6) |  | 3 | 4369 | 68.7 (14.2, 200.7)
75-79 |  | 51.5 |  |  |  | 51 | 36061 | 141.4 ( 102.6, 180.2) |  | 3 | 9986 | 30.0 (6.2, 87.8) |  | 4 | 4125 | 97.0 (26.4, 248.3)
80-84 |  | - |  | - |  | 41 | 25746 | 159.2 ( 110.5, 208.0) |  | 3 | 3298 | 91.0 (18.8, 265.8) |  | 4 | 2387 | 167.6 (45.7, 429.0)
85+ |  | - |  | - |  | 0 | 0 | - |  | 0 | 0 | - |  | 2 | 462 | 432.9 (52.4, 1563.8)
 |  |  |  |  |  | 450 |  |  |  | 13 |  |  |  | 23 |  | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
Age-standardized rate* |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
40-69 |  |  |  |  |  |  |  | 16.6 (14.7, 18.6) |  |  |  | - |  |  |  | 20.8 (5.5, 36.0)
40-79 |  |  |  |  |  |  |  | 25.8 (23.6, 28.1) |  |  |  | 7.0 (3.8, 10.1) |  |  |  | 26.3 (20.9, 31.7)
40+ |  |  |  |  |  |  |  | 27.5 (25.2, 29.8) |  |  |  | 8.2 (5.0, 11.3) |  |  |  | 34.9 (29.0, 40.7)
*Age-standardized to the 2000 IARC World population, ages 40-79, only presented if 10 or more events occurred within specified age-range
†  For strata with less than 10 events, the confidence intervals were calculated using Fisher's exact test
Abbreviations as follows:
[NAME] = Six prefectures study [24]
JACC = Japanese Collaborative Cohort Study [25]
KCPS = Korean Cancer Prevention Study [27]
MEC = Mutliethnic Cohort [22]
Three Prefectures = Three Prefectures Study [26]
Spreadsheet: 674134d1587672610-assistance-with-vlookup-function-2020-04-23-oeldere-pt-674130d1587671321-assistance-with-vlookup-function-book1
Sheet: Sheet1

Table 1 |  |  |  |  | Table 2 |  |  |  | Oeldere
Employee | 2020-04-03 00:00:00 | 2020-04-10 00:00:00 | 2020-04-17 00:00:00 |  | Employee | Date | Hours |  | Som van Hours | Kolomlabels
Number 1 |  |  |  |  | Number 1 | 2020-04-03 00:00:00 | 4.5 |  | Rijlabels | 2020-04-03 00:00:00 | 2020-04-10 00:00:00 | 2020-04-17 00:00:00 | Eindtotaal
Number 2 |  |  |  |  | Number 2 | 2020-04-17 00:00:00 | 0.5 |  | Number 1 | 4.5 |  |  | 4.5
Number 3 |  |  |  |  | Number 2 | 2020-04-10 00:00:00 | 1.5 |  | Number 10 | 0.5 |  | 0.25 | 0.75
Number 4 |  |  |  |  | Number 2 | 2020-04-03 00:00:00 | 1.25 |  | Number 2 | 1.25 | 1.5 | 0.5 | 3.25
Number 5 |  |  |  |  | Number 3 | 2020-04-03 00:00:00 | 2 |  | Number 3 | 27 |  |  | 27
Number 6 |  |  |  |  | Number 3 | 2020-04-03 00:00:00 | 25 |  | Number 4 | 2 | 4 |  | 6
Number 7 |  |  |  |  | Number 4 | 2020-04-03 00:00:00 | 2 |  | Number 5 | 8 | 5 |  | 13
Number 8 |  |  |  |  | Number 4 | 2020-04-10 00:00:00 | 4 |  | Number 6 |  |  | 5.5 | 5.5
Number 9 |  |  |  |  | Number 5 | 2020-04-03 00:00:00 | 8 |  | Number 7 | 8 | 4 |  | 12
Number 10 |  |  |  |  | Number 5 | 2020-04-10 00:00:00 | 5 |  | Number 8 | 1 |  |  | 1
 |  |  |  |  | Number 6 | 2020-04-17 00:00:00 | 5.5 |  | Number 9 | 2 |  | 2 | 4
 |  |  |  |  | Number 7 | 2020-04-03 00:00:00 | 8 |  | Eindtotaal | 54.25 | 14.5 | 8.25 | 77
 |  |  |  |  | Number 7 | 2020-04-10 00:00:00 | 4
 |  |  |  |  | Number 8 | 2020-04-03 00:00:00 | 1
 |  |  |  |  | Number 9 | 2020-04-03 00:00:00 | 2
 |  |  |  |  | Number 9 | 2020-04-17 00:00:00 | 2
 |  |  |  |  | Number 10 | 2020-04-03 00:00:00 | 0.5
 |  |  |  |  | Number 10 | 2020-04-17 00:00:00 | 0.25
Hello
I hope all is safe and sound.
I am facing a problem with VLOOKUP function and I would like your help on this.
In the attached excel sheet I have two tables, table 2 is the raw data I receive and table 1 is the dataset I want to make.
My purpose is whenever table 2 is being updated, then table 1 will be updated accordingly and automatically.
The problem lays with the contents of table 2:
Problem 1: Number 2 has 3 entries, each on different date. But when I use VLOOKUP in cell [NAME] I receive the data from the first entry of number 2 in table 2. I would like [NAME] in table 1 to show the hours of employee number 2 on 03/04/2020. Is this possible without adding a helper column?
Problem 2: Number 3 has 2 entries, both on same date. Is it possible that cell [NAME] in table 1 to show the sum hours of employee number 3 on 03/04/2020?
Any help and advice will be much appreciated!
Spreadsheet: 726769d1617442201-sumifs-function-doesnt-calculate-values-as-expected-accounting-module
Sheet: Balance Sheet

 | Balance Sheet |  |  | Use this "Opening balances" column if you traded in the previous tax year and have balance sheet totals from that - delete this comment when you no longer need it (click cell E2 and hit delete on keyboard)
 |  |  |  | If all you had was an opening bank balance but no balance sheet - enter the amount next to Capital (cell E31); you can also enter it next to the Bank (cell E8)
 |  |  |  |  | Month1 | Month2 | Month3 | Month4 | Month5 | Month6 | Month7 | Month8 | Month9 | Month10 | Month11 | Month12
 |  |  |  | Opening Balances
 |  | Assets
 |  | Bank |  | 2000
 |  | Inventory (Stock on Hand Value)
 |  | Total Assets
 |  | Liabilities
 |  | Total Liabilities
 |  | Total Net Assets
 |  | (Assets less Liabilities)
 |  | Equity
 |  | Current Year Earnings (Net Profit/Loss) |  | xxxxxxxx
 |  | [NAME]
 |  | Total Equity
 |  |  |  |  | Month1 | Month2 | Month3 | Month4 | Month5 | Month6 | Month7 | Month8 | Month9 | Month10 | Month11 | Month12
 |  | Total Equity must equal Total Net Assets |  | Difference
Spreadsheet: 698306d1601913275-if-statement-with-networkdays-error-ge-parts-logistics-tracker-we41
Sheet: Summary - CoE

Shipment Status | (Multiple Items)
Power Station | (All)
 | Values
Row Labels | Count of No | Sum of Shipment Value (USD)
France | 9 | 426162.5984000001
Germany | 5 | 185288.488
UK | 1 | 38091.4656
Grand Total | 15 | 649542.552
Spreadsheet: 134781d1325627617-excel-2007-create-list-on-new-worksheet-based-on-cell-value-book1-4-
Sheet: Master

Investor Number | HAM Eligible? | PRA | UP | HAFA
00064 | No | yes |  | no
00085 | No | no | no | no
00086 | No | no | no | yes
00088 | yes | no | no
02001 | yes |  |  | yes
02011 | yes | yes | yes | no
02012 |  |  | yes
02025 |  | no | no | no
02067
Spreadsheet: jason_wolfe__13343__Gas_VolMgmt_Metrics
Sheet: Metrics Form

User Name:
Date:
UNIFY Sybase Metrics (Gas Volume Management)
 |  |  |  |  |  | Sybase |  | User Test 1 |  | Variance (Sybase - User Test 1)
Area / Process | Entity | Pipeline | Time | Window(s) Involved | Filter Criteria Used | Time to Retrieve Filter | Time to Run Process / Report | Time to Retrieve Filter | Time to Run Process / Report | Time to Retrieve Filter | Time to Run Process / Report | Concurrent Processes Running | Comments
Volume Management
Pipeline Imbalance Statement
Broker Balancing
Balance Process
Create Accounting Arrangements
Revenue Volume Comparison
Deal Volume Tracking Report
Update Rate Details
Day 2
Sales/Supply Recon Report
Volume Management Report 07
Inter-desk/Interconnect Report
Missing Service Rates Report
Accounting Transactions by G/L Month
Spreadsheet: stacey_white__39052__Summary Oct 15
Sheet: summary 1015

SUMMARY BY WEEK FOR  09/04-09/07
TOTAL ISSUES
Category |  | Description
A |  | Deal Capture
B |  | Deal Valuation
C |  | Breakdown in Officializing Process- Human
D1 |  | Breakdown in Officializing Process- IT (UK)
D2 |  | Breakdown in Officializing Process- IT (US)
E |  | Curve Issues
F |  | Uncontrollable-System Needs to Change
G |  | Miscellaneous
H |  | Not identified
Breakdown By Group |  |  |  |  |  |  |  | # of Issues |  | Biggest Problem
EIM
EGM
EEL
EA-CAN
EA - GAS
EA - POWER
EES
EBS
Other
TOTAL ISSUES
Spreadsheet: 47391d1246428734-vlookup-help-example
Sheet: Sheet2

My list
C/I | C/O | Nts | Guest Name | Folio No. | PCR No. | staff ID | Room rate | F&B | Total Room
2009-05-27 00:00:00 | 2009-05-28 00:00:00 | 1 | Name1 | 1234567 | 698248792 | ls | 100 | 10 | 100
2009-05-27 00:00:00 | 2009-05-28 00:00:00 | 1 | [NAME] | 9876543 | 698248558 | ls | 200 | 20 | 200
2009-05-27 00:00:00 | 2009-05-28 00:00:00 | 1 | Name3 | 1472583 | 698248516 | ls | 300 | 30 | 300
2009-05-27 00:00:00 | 2009-05-28 00:00:00 | 1 | Name4 | 1237894 | 698273593 | ls | 400 | 40 | 400
2009-05-27 00:00:00 | 2009-05-28 00:00:00 | 1 | Name5 | 3219876 | 698273551 | ls | 500 | 50 | 500
2009-05-27 00:00:00 | 2009-05-28 00:00:00 | 1 | Name6 | 1597531 | 698273072 | ls | 600 | 60 | 600
Spreadsheet: 732894d1621290449-help-with-formula-copy-from-one-area-to-another-to-simplify-view-scheduling-file-not-working
Sheet: Teams Entered

# | Team Name | GS | GP | Win | Loss | Tie | Runs Against | Runs For | [NAME] | RPG | [NAME] | Win %
1 | Reno Huskies
2 | McQueen Lancers
3 | Bishop Manogue Miners
4 | Spanish Springs Cougars
5 | Damonte Ranch Mustangs
6 | Carson Senators
7 | Reed Raiders
8 | [NAME]
9 | Galena Grizzlies
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Spreadsheet: 865672d1712696974-add-up-per-month-pasta1
Sheet: Total

 |  | Planilha1 | Planilha2
 | 2022-01-01 00:00:00
 | 2022-02-01 00:00:00
 | 2022-03-01 00:00:00
 | 2022-04-01 00:00:00
 | 2022-05-01 00:00:00
 | 2022-06-01 00:00:00
 | 2023-01-01 00:00:00
 | 2023-02-01 00:00:00
 | 2023-03-01 00:00:00
 | 2023-04-01 00:00:00
 | 2023-05-01 00:00:00
 | 2023-06-01 00:00:00