tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 698498d1602007176-need-to-get-reports-from-badly-formatted-exported-data-leave-example-2-
Sheet: Bernie approach

Between 01-Sep-2020 and 30-Sep-2020
Location
Location |  |  |  |  |  |  | Leave | Start | End | Days | Hours | Who
Surname, Name A
Holiday | [NAME] | Absence End | Duration | Hours | Reason
2020-09-14 00:00:00 | 2020-09-18 00:00:00 | 5 | 37.5
Total Holiday | 5 | 37.5
Employee Total: Surname, Name A | 5 | 37.5
Surname, Name B
Holiday | [NAME] | Absence End | Duration | Hours | Reason
2020-09-28 00:00:00 | 2020-09-29 00:00:00 | 2 | 15
Total Holiday | 2 | 15
Employee Total: Surname, Name B | 2 | 15
Surname, Name C
Holiday | [NAME] | Absence End | Duration | Hours | Reason
2020-09-25 00:00:00 | 2020-09-25 00:00:00 | 0.5 | 3.75
Total Holiday | 0.5 | 3.75
Employee Total: Surname, Name C | 0.5 | 3.75
Surname, Name D
Ordinary Maternity Leave | [NAME] | Absence End | Duration | Hours | Reason
2020-05-10 00:00:00 | 2020-11-07 00:00:00 | 130 | 975
Total Ordinary Maternity Leave | 22 | 165
Employee Total: Surname, Name D | 22 | 165
Surname, Name E
Holiday | [NAME] | Absence End | Duration | Hours | Reason
2020-09-01 00:00:00 | 2020-09-04 00:00:00 | 4 | 28.5
Total Holiday | 4 | 28.5
Employee Total: Surname, Name E | 4 | 28.5
Totals: Location | 33.5 | 249.75
Want a table on a separate tab that shows
Leave type
# Days (col c)
Who that employee is
Spreadsheet: 673394d1587363405-excel-copy-contents-from-one-sheet-to-another-without-vba-macro-sampledata
Sheet: SalesOrders

OrderDate | Region | Rep | Item | Units | Unit Cost | Total
2019-01-06 00:00:00 | East | Jones | Pencil | 95 | 1.99 | 189.05
2019-01-23 00:00:00 | Central | Kivell | Binder | 50 | 19.99 | 999.4999999999999
2019-02-09 00:00:00 | Central | [NAME] | Pencil | 36 | 4.99 | 179.64
2019-02-26 00:00:00 | Central | [NAME] | Pen | 27 | 19.99 | 539.7299999999999
2019-03-15 00:00:00 | West | Sorvino | Pencil | 56 | 2.99 | 167.44
2019-04-01 00:00:00 | East | Jones | Binder | 60 | 4.99 | 299.4
2019-04-18 00:00:00 | Central | [NAME] | Pencil | 75 | 1.99 | 149.25
2019-05-05 00:00:00 | Central | [NAME] | Pencil | 90 | 4.99 | 449.1
2019-05-22 00:00:00 | West | Thompson | Pencil | 32 | 1.99 | 63.68
2019-06-08 00:00:00 | East | Jones | Binder | 60 | 8.99 | 539.4
2019-06-25 00:00:00 | Central | Morgan | Pencil | 90 | 4.99 | 449.1
2019-07-12 00:00:00 | East | [NAME] | Binder | 29 | 1.99 | 57.71
2019-07-29 00:00:00 | East | Parent | Binder | 81 | 19.99 | 1619.19
2019-08-15 00:00:00 | East | Jones | Pencil | 35 | 4.99 | 174.65
2019-09-01 00:00:00 | Central | Smith | Desk | 2 | 125 | 250
2019-09-18 00:00:00 | East | Jones | Pen Set | 16 | 15.99 | 255.84
2019-10-05 00:00:00 | Central | Morgan | Binder | 28 | 8.99 | 251.72
2019-10-22 00:00:00 | East | Jones | Pen | 64 | 8.99 | 575.36
2019-11-08 00:00:00 | East | Parent | Pen | 15 | 19.99 | 299.85
2019-11-25 00:00:00 | Central | Kivell | Pen Set | 96 | 4.99 | 479.04
2019-12-12 00:00:00 | Central | Smith | Pencil | 67 | 1.29 | 86.43
2019-12-29 00:00:00 | East | Parent | Pen Set | 74 | 15.99 | 1183.26
2020-01-15 00:00:00 | Central | [NAME] | Binder | 46 | 8.99 | 413.54
2020-02-01 00:00:00 | Central | Smith | Binder | 87 | 15 | 1305
2020-02-18 00:00:00 | East | Jones | Binder | 4 | 4.99 | 19.96
2020-03-07 00:00:00 | West | Sorvino | Binder | 7 | 19.99 | 139.93
2020-03-24 00:00:00 | Central | [NAME] | Pen Set | 50 | 4.99 | 249.5
2020-04-10 00:00:00 | Central | [NAME] | Pencil | 66 | 1.99 | 131.34
2020-04-27 00:00:00 | East | [NAME] | Pen | 96 | 4.99 | 479.04
2020-05-14 00:00:00 | Central | [NAME] | Pencil | 53 | 1.29 | 68.37
2020-05-31 00:00:00 | Central | [NAME] | Binder | 80 | 8.99 | 719.2
2020-06-17 00:00:00 | Central | Kivell | Desk | 5 | 125 | 625
2020-07-04 00:00:00 | East | Jones | Pen Set | 62 | 4.99 | 309.38
2020-07-21 00:00:00 | Central | Morgan | Pen Set | 55 | 12.49 | 686.95
2020-08-07 00:00:00 | Central | Kivell | Pen Set | 42 | 23.95 | 1005.9
2020-08-24 00:00:00 | West | Sorvino | Desk | 3 | 275 | 825
2020-09-10 00:00:00 | Central | [NAME] | Pencil | 7 | 1.29 | 9.030000000000001
2020-09-27 00:00:00 | West | Sorvino | Pen | 76 | 1.99 | 151.24
2020-10-14 00:00:00 | West | Thompson | Binder | 57 | 19.99 | 1139.43
2020-10-31 00:00:00 | Central | [NAME] | Pencil | 14 | 1.29 | 18.06
2020-11-17 00:00:00 | Central | [NAME] | Binder | 11 | 4.99 | 54.89
2020-12-04 00:00:00 | Central | [NAME] | Binder | 94 | 19.99 | 1879.06
2020-12-21 00:00:00 | Central | [NAME] | Binder | 28 | 4.99 | 139.72
Spreadsheet: 329851d1404421509-vlookup-partial-number-in-excel-book1
Sheet: Sheet1

Need to populate column B based on vlookup of column A in column E and return the value in column F (in yellow).
With the phone numbers being in different formats in column A compared to column E, I have to use the last 8 digits of A in the vlookup.
Phone Number | Referred From | Should Be… |  | Phone Number | Referred From
[PHONE] |  | Magazine |  | 41321321321 | Website
[PHONE] |  | Poster |  | 4465245612 | TV
[PHONE] |  | TV |  | 440123987546 | [NAME]
 |  |  |  | 4102357894 | Poster
 |  |  |  | 4401234567890 | Magazine
 |  |  |  | 4498568741 | Website
 |  |  |  | 44789564545 | TV
 |  |  |  | 4456565656 | [NAME]
 |  |  |  | 4409876543210 | Poster
 |  |  |  | 440123987654 | Magazine
 |  |  |  | 4421534697 | Website
 |  |  |  | 440123123123 | TV
 |  |  |  | 410123564123 | [NAME]
 |  |  |  | 44789456123 | Poster
 |  |  |  | 440132132131 | Magazine
Spreadsheet: benjamin_rogers__1211__BasePowerModel Final Version-3-19-00
Sheet: BS

BALANCE SHEET
 |  | 0
('000 $) |  | Close
Assets
Cash |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Accounts Receivable |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Inventories |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other Current Assets |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Debt Service Reserve |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Current Assets
Gross PP&E
Accumulated Depreciation |  | 0
Net PP&E
Land
Other Assets |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Assets
Liabilities
Accounts Payable |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Accrued Expenses |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Deferred Tax Liability |  | 0
Working Capital Revolver |  | 0
Long Term Debt
Other Non-Current Liabilities |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Long-term Liabilities
Stockholders' Equity
Paid-In-Capital
Retained earnings
Total stockholders' equity
Total Liabilities & Equity
Proof
Spreadsheet: 84625d1284654984-count-number-of-wrong-name-reporting
Sheet: Summary

Site | Accepted | Declined | IR Recoded | Pending | Total Submitted
[NAME] | 0 |  |  |  | 0
Coos Bay | 0 |  |  |  | 0
El Paso | 0 |  |  |  | 0
Houston | 0 |  |  |  | 0
Nashville | 0 |  |  |  | 0
Pikeville | 0 |  |  |  | 0
Portland | 0 |  |  |  | 0
Santo [NAME] | 0 |  |  |  | 0
Total | 0 | 0 | 0 | 0 | 0
Accepted |  | Declined |  | Recoded
[NAME] |  | States Issue Resolved |  | States Issue Resolved
Another Dept |  | [NAME]
 |  | Another Dept
Spreadsheet: 867488d1714367967-generate-serial-number-and-then-restart-book1
Sheet: Sheet1

 |  | Sr. # | [NAME] | Sales
 |  | 1 | a
 |  | 2 | a
 |  | 1 | b
 |  | 2 | b
 |  | 3 | b
 |  | 4 | b
 |  | 1 | c
 |  | 2 | c
 |  | 3 | c
 |  | 1 | d
 |  | 2 | d
 |  | 3 | d
 |  | 4 | d
 |  | 5 | d
 |  | 6 | d
Spreadsheet: darron_c_giron__7992__midland_cogen
Sheet: firm9806

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1998-06-01 00:00:00
IFGMR (TRKL/TX) |  |  | 1.95 |  |  | No. of Days: | 30
IFGMR (TRKL/LA) |  |  | 1.94
IFGMR (PEPL/TX/OK) |  |  | 1.94
IFGMR (ANR/LA) |  |  | 1.95
IFGMR (HENRY HUB) |  |  | 2.03
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001
 | 1993 | 2.4 | 2002
 | 1994 | 2.51 | 2003
 | 1995 | 2.61 | 2004
 | 1996 | 2.53 | 2005
 | 1997 | 2.65 | 2006
 | 1998 |  | 2007 | 6.37
 | 1999
 | 2000
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: 870286d1716825164-modifying-table-to-be-more-dynamic-book2-1-
Sheet: Haldusaruanne

FinSummaHaldus |  |  |  | Kulukoht
Code | [NAME] | Client | Year | 5300 [NAME] otsused ja kohustused | 5353 Remondifondi laekumine | 5312 [NAME] intressid | 5352 Kapiralirendi põhiosa maksed
SEEMNE200 | 70000869 | Client1 | 2024 | 2636.04 | 48154.07999999999 | 3000 | 1000
SEEMNE200 | 70000869 | Client1 | 2025 | 2636.04 | 48154.07999999999 | 5000 | 1000
SEEMNE200 | 70000869 | Client1 | 2026 | 2636.04 | 48154.07999999999 | 2000 | 1000
SEEMNE200 | 70000869 | Client1 | 2027 | 2636.04 | 48154.07999999999 | 4000 | 1000
SEEMNE200 | 70000869 | Client1 | 2028 | 2636.04 | 48154.07999999999 | 2000 | 1000
PURAVIKU4 | 70000869 | Client2 | 2024 | 8997.240000000002 | 45182.16 | 1000 | 1000
PURAVIKU4 | 70000869 | Client2 | 2025 | 8997.240000000002 | 45182.16 | 2000 | 1000
PURAVIKU4 | 70000869 | Client2 | 2026 | 8997.240000000002 | 45182.16 | 3000 | 1000
PURAVIKU4 | 70000869 | Client2 | 2027 | 8997.240000000002 | 45182.16 | 4000 | 1000
PURAVIKU4 | 70000869 | Client2 | 2028 | 8997.240000000002 | 45182.16 | 3000 | 1000
Spreadsheet: 831560d1685716596-project-and-keywords-problem-solving-projects-keywords-pb
Sheet: Expected-results

Mot-clef \ Projet | 1. DEPth | 2. LatexDry | 3. LIPIDIC_PURGE | 4. MISSION | 5. PESTIPOND | 6. POLYGLOT | 7. Pristine | 8. ReinitiaTOR | 9. SOFTACTION | 10. SynPPR | 11. BODYTEG | 12. [NAME] | 13. CORELMAG | 14. C-Sil | 15. Digital-LbL | 16. EVOBAR | 17. GOT | 18. LipidTrans4NeuroTraffic | 19. LUCAS | 20. MESAMM | 21. [NAME] | 22. NetOnTime | 23. PA-Box | 24. POPSYCLE | 25. SignOp | 26. [NAME] | 27. URBANTIT | u01. [NAME] | u02. DInnAMICS | u03. BattAllox | u04. [NAME] | u05. N-FLAMS | u06. PSLM | u07. InsuRAF | u08. GIGA | u09. LeBHel-Amzymes | u10. [NAME] | u11. SPERRY | u12. [NAME] | u13. BrightSwitch | u14. QDDA | u15. SP-Fluo | u16. [NAME] | u17. AFINITE | u18. TROC | u19. [NAME] | u20. nano-NET | u21. NanoLys | u22. BioconjUgi | u23. [NAME] | u24. MethAmAbs
1. DEPth
2. LatexDry
3. LIPIDIC_PURGE
4. MISSION
5. PESTIPOND
6. POLYGLOT
7. Pristine
8. ReinitiaTOR
9. SOFTACTION
10. SynPPR
11. BODYTEG
12. [NAME]
13. CORELMAG
14. C-Sil
15. Digital-LbL
16. EVOBAR
17. GOT
18. LipidTrans4NeuroTraffic
19. LUCAS
20. MESAMM
21. [NAME]
22. NetOnTime
23. PA-Box
24. POPSYCLE
25. SignOp
26. [NAME]
27. URBANTIT
u01. [NAME]
u02. DInnAMICS
u03. BattAllox
u04. [NAME]
u05. N-FLAMS
u06. PSLM
u07. InsuRAF
u08. GIGA
u09. LeBHel-Amzymes
u10. [NAME]
u11. SPERRY
u12. [NAME]
u13. BrightSwitch
u14. QDDA
u15. SP-Fluo
u16. [NAME]
u17. AFINITE
u18. TROC
u19. [NAME]
u20. nano-NET
u21. NanoLys
u22. BioconjUgi
u23. [NAME]
u24. MethAmAbs
Spreadsheet: daren_farmer__6652__Gas Assets Ops 03-00 Prelim O&M
Sheet: 2664 - Texas Logistics

2664 |  |  |  |  |  |  |  |  |  |  |  |  |  | ASSOCHC | TOTAL_HEADCOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ALYSTHC | 2000-01-01 00:00:00 |  | 2000-02-01 00:00:00 |  | 2000-03-01 00:00:00 |  | 2000-04-01 00:00:00 |  | 2000-05-01 00:00:00 |  | 2000-06-01 00:00:00 |  | 2000-07-01 00:00:00 |  | 2000-08-01 00:00:00 |  | 2000-09-01 00:00:00 |  | 2000-10-01 00:00:00 |  | 2000-11-01 00:00:00 |  | 2000-12-01 00:00:00
 |  | ACTUAL |  | PLAN2000 |  |  |  | ACTUAL |  | PLAN2000
 |  | M.PER |  | M.PER |  |  |  | M.YTD |  | M.YTD |  |  |  |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER
 |  |  |  |  |  | Monthly |  |  |  |  |  | YTD |  |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 |  | Actual |  | Plan |  | [NAME] |  | Actual YTD |  | Plan YTD |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Direct Expense:
TOT_COMP | Compensation |  |  |  |  |  |  |  |  |  |  |  |  | Headcount
[NAME] | Benefits and Payroll Taxes |  |  |  |  |  |  |  |  |  |  |  |  | Analysts and Associates
TOT_EMP_EXP | Employee Expenses
TOT_RECRUITING | Recruiting & Relocations
TOT_OSIDE_SERV | Outside Services |  |  |  |  |  |  |  |  |  |  |  |  | Direct Expense:
[NAME] | Supplies and Expense |  |  |  |  |  |  |  |  |  |  |  |  | Compensation
TOT_MKT | Marketing |  |  |  |  |  |  |  |  |  |  |  |  | Benefits and Payroll Taxes
TOT_CHAR_CONT | Charitable Contributions |  |  |  |  |  |  |  |  |  |  |  |  | Employee Expenses
TOT_RENT | Rent (3rd Party) |  |  |  |  |  |  |  |  |  |  |  |  | Recruiting & Relocations
TOT_TECH | Technology |  |  |  |  |  |  |  |  |  |  |  |  | Outside Services
TOT_TRANS | Transportation |  |  |  |  |  |  |  |  |  |  |  |  | Supplies and Expense
CORP_IT | Corporate IT |  |  |  |  |  |  |  |  |  |  |  |  | Marketing
CORP_RENT | Corporate Rent |  |  |  |  |  |  |  |  |  |  |  |  | Charitable Contributions
TOT_OTH_EXP | Other Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Rent (3rd Party)
[NAME] | Taxes Other Than Income |  |  |  |  |  |  |  |  |  |  |  |  | Technology
[PHONE] | Capital Allocation |  |  |  |  |  |  |  |  |  |  |  |  | Transportation
TOT_DEP_AMOR | Depreciation & Amortization |  |  |  |  |  |  |  |  |  |  |  |  | Corporate IT
 | Total Direct Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Corporate Rent
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Expenses
9230999860 | Allocated Intercompany Billings |  |  |  |  |  |  |  |  |  |  |  |  | Taxes Other Than Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Capital Allocation
 | Net Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Depreciation & Amortization
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Direct Expenses
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Allocated Intercompany Billings
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Expenses
Spreadsheet: 72202d1272909681-column-numbers-for-vlookup-vlookup-question
Sheet: Before

Vlookup | Region | Data1 | Data2 | Value | Data3
3 | East | Data1 | Data2 | 1 | Data3
 | West | Data1 | Data2 | 2 | Data3
 | North | Data1 | Data2 | 3 | Data3
 | South | Data1 | Data2 | 4 | Data3
Spreadsheet: 848369d1699090882-separation-digits-martha-aligw
Sheet: Sheet1

7.1.2 Helferstunden
2.2.89 Zulage Geotextilunterlage
3.1.10
3.1.7
3.1.8
3.1.9
4.1.1
4.1.10 Leerrohre DN 100
4.1.13 Leerrohrgraben (Maschinenaushub)
4.1.11 Leerrohre DN 150
4937FXLEI0 Tdo 4.1.1
4937FXLEI0 TDo 4.1.8 Schotter für Ausbes
4937FXLEI0 TDo 7.1.2 Helferstunden
Spreadsheet: 779297d1651685242-to-let-cell-value-in-one-column-move-according-to-value-in-another-column-vlookup-data-book1
Sheet: Raw Data

 | *Data obtained and [NAME] from ERP source, the sequence will be different next time after adding new data in between the current sequence
 |  |  |  |  | My question: To enable the cell value in Column B move around according to cell value in Raw Data
 |  |  |  |  | Example: If next time the sequence is changed as below: any method to let Column B fixed according to Raw Data (Other than IF formula)?
 | Data to be input based on Raw data |  |  |  | After adding new raw data and the sequence is changed |  |  |  |  |  |  | Desired output:
 | Raw Data* | Column B |  |  | Raw Data* |  | Column B |  |  |  |  | Raw Data* |  | Column B
 | America | 1 |  |  | America |  |  |  |  |  |  | America | <---------- | 1
 | Brazil | 2 |  |  | Brazil |  |  |  |  |  |  | Brazil | <---------- | 2
 | Canada | 3 |  |  | Brunei |  |  |  |  |  |  | Brunei
 | Denmark | 4 |  |  | Canada |  |  |  |  |  |  | Canada | <---------- | 3
 | Egypt | 5 |  |  | Cambodia |  |  |  |  |  |  | Cambodia
 | France | 6 |  |  | Denmark |  |  |  |  |  |  | Denmark | <---------- | 4
 | Germany | 7 |  |  | Egypt |  |  |  |  |  |  | Egypt | <---------- | 5
 |  |  |  |  | France |  |  |  |  |  |  | France | <---------- | 6
 |  |  |  |  | Germany |  |  |  |  |  |  | Germany | <---------- | 7
Spreadsheet: louise_kitchen__24114__KO_Netco Grp _ EEs on 12-19
Sheet: HR

Human Resources
GISID | EMPLOYEE_NAME | [NAME] | JOBGROUP
90008462 | BROUSSARD, THARSILLA M | Spec HR | SPEC-CS
90104467 | BUCKLEY, KAREN | [NAME] | SPECSR-CS
90125765 | CASHION, TANA K | HR Associate - Rotation 5 | ASSOCHR-CS
90123650 | CLYATT, JULIE | [NAME] | COORD-CS
90008612 | CURLESS, AMANDA K | Spec HR | SPEC-CS
90040883 | DAVIES, [NAME] | Dir HR | DIR-CS
90127508 | FITZPATRICK, AMY | Mgr HR | MGR-CS
90040919 | JARRETT, ANTHONY R | Spec Benefits | SPEC-CS
90008766 | KEARNEY, JULIE | Mgr HR | MGR-CS
90130907 | LABBE, ANNE | HR Analyst - Rotation 1 | ANLHR-CS
90008701 | OQUINN, KARI J | Mgr HR | MGR-CS
90008585 | OXLEY, [NAME] | VP HR | VP-CS
90007218 | SLONE, JEANNE E | Mgr HR | MGR-CS
90154262 | ZARKOWSKY, SARAH J | HR Associate - Rotation 1 | ASSOCHR-CS
 |  | Employees
Spreadsheet: 193331d1352804672-autofill-from-multiple-sheets-test
Sheet: 13003

Design & Drafting Invoice
sample
sample
sample
sample
Customer | Client 1
Date | 2012-11-02 00:00:00
Invoice number
Reference | Labour to Date
Bank Details
Account Name | Sample Company
BSB & Account Number | 123456789
Branch | Sample Company
ABN Number | 123456789
Description | Date | Hours | Rate (p/h) | Subtotal
Item 1 | 2012-11-04 00:00:00 | 1 | 60
Item 2 | 2012-11-05 00:00:00 | 2 | 60
Item 3 | 2012-11-06 00:00:00 | 3 | 60
Item 4 | 2012-11-07 00:00:00 | 4 | 60
Item 5 | 2012-11-08 00:00:00 | 5 | 60
Item 6 | 2012-11-09 00:00:00 | 6 | 60
Item 7 | 2012-11-10 00:00:00 | 7 | 60
Item 8 | 2012-11-11 00:00:00 | 8 | 60
Item 9 | 2012-11-12 00:00:00 | 9 | 60
Item 10 | 2012-11-13 00:00:00 | 10 | 60
Totals
 |  | GST
 |  | Total Amount Due
 |  | Due Date
Notes
 |  | Paid |  | NO
 |  | Sent |  | NO
Spreadsheet: 839882d1692278262-count-on-match-formula-excel-help-v1-1-a-ligw
Sheet: Help

NAME | LEVEL |  | NAME | High | Meduim | Low |  | Question
[NAME] | High |  | [NAME] |  |  |  | < | Need formula to populate how many of each level for each person
[NAME] | Medium |  | [NAME]
[NAME] | Low |  | [NAME]
[NAME] | High |  | [NAME]
Elizah | Medim |  | Elizah
Fred | Low |  | Fred
[NAME] | High |  | [NAME]
[NAME] | Medim |  | [NAME]
[NAME] | Low |  | [NAME]
[NAME] | High |  | [NAME]
Jenifer | Medim |  | Jenifer
[NAME] | High
[NAME] | Medium
[NAME] | Low
[NAME] | High
Elizah | Medim
Fred | Low
[NAME] | High
[NAME] | Medim
[NAME] | Low
[NAME] | High
Jenifer | Medim
[NAME] | High
[NAME] | Medium
[NAME] | Low
[NAME] | High
Elizah | Medim
Fred | Low
[NAME] | High
[NAME] | Medim
[NAME] | Low
[NAME] | High
Jenifer | Medim
Spreadsheet: 479666d1473488143-sum-of-multiple-entries-by-id-forum-sample
Sheet: Lists

 |  |  |  |  |  |  | Code | Category |  | Group | Budget | Actual | Details
 |  |  |  |  |  |  | 4887 | Food & Beverage |  | Groceries | 1000
 |  |  |  |  |  |  | 5500 | Clothing |  | Personal Expenses | 500
 |  |  |  |  |  |  | 6500 | Subscriptions |  | Leisure | 150
 |  |  |  |  |  |  | 7100 | Prescriptions |  | Medical | 260
 |  |  |  |  |  |  | 8100 | [NAME] |  | Transport | 525
Spreadsheet: 5265d856-bc0d-48c1-b5bf-1ef8f5d5116e
Sheet: Sheet1

LAND ACQUISITION INFORMATION | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | PARCEL | PROPERTY OWNER'S | AMOUNT | APPRAISED | APPRAISAL | RECORDED PROPERTY | RECORDING | SURVEY FEE | ATTORNEY FEE
ITEM | [NAME] | NAME | FOR PARCEL | AMOUNT | SUBMITTED | SUBMITTED | FEES | (INCL. INVOICE) | (INCL. INVOICE)
 | (LOT, EASEMENT XX FT.) |  | (INCL. INVOICE) | $ | (YES / NO)
 |  |  |  |  | INVOICE AMT
 | Mr. [NAME] farm, 201 main
 | 30ft x 150ft permanent easem. | Mr. And Mrs. [NAME]
EX, | and 0.5acre lot for pump sta.
Spreadsheet: 102367d1300314878-if-index-match-new-job-template2
Sheet: Cabinets Detail

ESTIMATE OF WORK
 |  |  |  |  |  |  | Date: | 2011-03-16 00:00:00
Contractor: | LaMorinda Tile and Stone |  |  | Job Name: | 0
Address: | 2261 Commerce Ave., Suite B |  |  | Address: | 0
City: | Concord, CA 94520 |  |  | City: | 0
Phone: | [PHONE] |  |  | Phone: | 0
Fax : | [PHONE] |  |  | Fax: | 0
[NAME]: | [EMAIL] |  |  | [NAME]: | 0
Detail of Work
Kitchen Cabinets Modular
 | [NAME] and doors
 | Solid maple plywood interiors
 | [NAME]-close slides
 | Pre-finished dovetail maple drawers
 | Standard Adjustable hinges
 | Adjustable shelves
 | Door type: Overlay
 |  | Door Style:
 |  | Drawer 5-piece to match door style
Item | Description |  |  |  | Color | Quantity | Price EA | Price
B09 | [NAME] 1 SHELF |  |  |  | K10 |  | 174.4291109 | 0
B27 | [NAME] DRAWER 2 DOOR 1 SHELF |  |  |  | D3 |  | 310.065 | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Discount | 0
 |  |  |  |  |  |  | Sub Total | 0
 |  |  |  |  |  |  | Tax | 0
 |  |  |  |  |  |  | Total | 0
Assembly |  |  |  |  |  |  | 15 | 0
Delivery |  |  |  |  |  |  |  | 150
Installation |  |  |  |  |  |  |  | 0
 | Mounting all Cabinets
 | Installing all mouldings
 | Installing door pulls
NOTE: | Cabinets do not come with pulls
 |  |  |  |  |  |  | Total: | 0
 | Accepted by:
 | Client |  |  |  |  |  | Date
Spreadsheet: 3e0495be-c307-4df7-8b49-b8ca0ae395a8
Sheet: CORRECTED-Mike's Special Pupil

SUMMARY FOR SPECIAL PUPIL AID:  FEBRRUARY 2008 CSA
FEBRUARY 2008 FORECAST |  |  | FY 2003 | FY 2004 | FY 2006 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | FY 2011 | FY 2012
1 | AMCPU
 | REVENUES
 | Basic
 | Gifted & Talented
 | Extended time
 | Basic Skills:
 |  | Compensatory
 |  | LEP
 |  | LEP Concentration
 | Sparsity
 | Transport Sparsity
 | Training & Experience
 | Late Contract Penalty
 | Operating Capital
 | Equity
 | Transition
 | Q Comp
 | Referendum Revenue
 | Alternative [NAME]:
 |  | Open Enroll/Charter Refer
 |  | Charter Basic Transport
 |  | Charter Ext TimeTransport
 |  | Charter Transport Sparsity
 |  | Faribault Alternative Attend Adj | 0 | 0
 | TOTAL REVENUE
 | LEVIES
 | Operating Capital Levy
 | Equity [NAME]
 | [NAME]
 | Q Comp
 | [NAME]
 | TOTAL LEVY
 | AID ENTITLEMENTS
 | Basic
 | Gifted & Talented
 | Extended time
 | Basic Skills:
 |  | Compensatory
 |  | LEP
 |  | LEP Concentration
 | Sparsity
 | Transport Sparsity
 | Training & Experience
 | Late Contract Penalty
 | Operating Capital
 | Equity
 | Transition
 | Q Comp
 | Referendum Equalization Aid
 | Tax Base Replacement Aid
 | Alternative [NAME]:
 |  | Open Enroll/Charter Refer
 |  | Charter Basic Transport
 |  | Charter Ext TimeTransport
 |  | Charter Transport Sparsity
 |  | Faribault Alternative Attend Adj | 0 | 0
 | TOTAL AID ENTITLEMENT
 | General Ed Entitlement
 | Tax Base Replacement Entitlement
 | TRA Reduction
 | Total Revenue = (22) + (53) =
 | Total Aid = (54) - (28) =
 | Current Year Adjusted Pupil Units
 | Aid per Pupil Unit = (55) / (56) =
 |  |  |  |  | 5585.06 | 5766.83 | 5892.35 | 5951.66 | 5934.15 | 5924.21
NOVEMBER 2010 FORECAST
 | Based on history files and pay11 levy |  |  |  |  |  |  | 5951 | 5866 | 5907 | 5960