tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 53022d1252941179-data-retrieve-from-a-8-by-9-table-table-test
Sheet: Sheet1

 | # of | # of
 | Apples | Oranges
 | 1 | 1
 | 4 | 1 |  | b26 AND the number of oranges in cell c4 matches the number of oranges in cells c18 through
 | 1 | 3 |  | L18, return the number in the  table that corresponds with the intersection of these two
 | 3 | 4 |  | variables.  In this case, the number 77 would be returned.
 | 1 | 2
 | 5 | 3
 | 1 | 4
 | 1 | 5
 | 2 | 1
 | 1 | 2
 | 2 | 3
 |  | Oranges | Oranges | Oranges | Oranges | Oranges | Oranges | Oranges | Oranges | Oranges | Oranges
 |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
Apples | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apples | 1 | 100 | 76.84366446703692 | 66.29285747871228 | 47.28295167181646 | 31.20353210985384 | 38.31871563529492 | 0 | 0 | 0 | 0
Apples | 2 | 50 | 42.55798895269605 | 34.91139306423987 | 34.16670344750769 | 27.06944575585798 | 20.6045308818025 | 28.6366969729868 | 0 | 0 | 0
Apples | 3 | 33.33333333333334 | 28.8858269480111 | 28.25828473419327 | 26.17816459727281 | 24.51830867771531 | 21.60683831723724 | 21.44058456980084 | 20.37875240622236 | 0 | 17.80254067305549
Apples | 4 | 25 | 23.97719243756329 | 23.95511733183034 | 20.97059742070677 | 21.43147220473299 | 18.12335933948339 | 19.89529609238238 | 15.31889903331511 | 0 | 16.26918462747694
Apples | 5 | 20 | 0 | 17.77308750966708 | 0 | 18.21887739103167 | 0 | 0 | 0 | 15.14128049996676 | 0
Apples | 6 | 0 | 0 | 0 | 0 | 0 | 13.76654175491953 | 0 | 0 | 0 | 0
Apples | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10.3198663614428 | 0 | 0
Spreadsheet: 767556d1644516381-find-values-that-appear-between-2-rows-based-on-text-values-see-description-and-attach-income-analysis-example-for-excel-forum-solved-
Sheet: Sheet1

Extracted values that I need to be dynamic.  I need to get ONLY the values that are located between the cells that say "Store Details" and "Total Store", but they will be located on diffent rows (always same column) depending on the specific store that runs the report. |  |  |  | Original report.  The number of rows and product codes will vary.  Number of columns and their locations will be static.
Charge Type | Period 1 Revenue | Period 2 Revenue |  | Column1 | Period 1 revenue | Period 2 revenue | Difference | address
 |  |  |  | Other Income
 |  |  |  | Damage | 35 | 48 | -13
 |  |  |  | Deposit | 70 | 88 | -18 |  |  |  | Cells shaded like this have static text values
 |  |  |  | 1ate charge | 80 | 43 | 37 |  |  |  | All un shaded cells in column A are variable
 |  |  |  | Mail Box | 375 | 500 | -125 |  |  |  | The number of rows in A is variable
 |  |  |  | Pavilion Rental | 206 | 200 | 6 |  |  |  | Ex: Store Details in this sheet is in cell A12.  If there were 3 more categories under Other Income, then "Store Details" would be in cell A15.
 |  |  |  | Big Wknd | 500 | 500 | 0
 |  |  |  | Donation | 40 | 60 | -20
 |  |  |  | Total Other Income $ | 1306 | 90 | 1216
 |  |  |  | Store Details
 |  |  |  | Consignments | 111 | 119 | -8
 |  |  |  | Ice Cream | 493 | 600 | -107
 |  |  |  | Dairy Products | 1 | 3 | -2
 |  |  |  | [NAME] | 965 | 400 | 565 |  |  |  | Store Details
 |  |  |  | Equipment Rental | 75 | 50 | 25 |  |  |  | Total Store
 |  |  |  | Groceries Non Taxable | 909 | 800 | 109
 |  |  |  | Health & Beauty Aids | 49 | 60 | -11
 |  |  |  | Household | 99 | 148 | -49
 |  |  |  | Ice Sales | 891 | 660 | 231
 |  |  |  | Laundry Income | -4 | 8 | -12
 |  |  |  | Pre Prepared Foods | 198 | 150 | 48
 |  |  |  | Paidouts | -53 | -40 | -13
 |  |  |  | Propane | 3802 | 3000 | 802
 |  |  |  | Accessories | 3091 | 6 | 3085
 |  |  |  | Souvenirs/Gifts | 480 | 300 | 180
 |  |  |  | Apparel | 79 | 66 | 13
 |  |  |  | Misc Sales | 1487 | 1000 | 487
 |  |  |  | Total Store | 12673 | 7330 | 5343
Spreadsheet: 1c6f6446-b9ea-496b-87e6-cc42d11a8948
Sheet: Page1_1

 |  |  | Colorado Department of Education |  |  | Page: 1
 |  |  | Business Rules
School Year: | 2013-14 | Dataset: | CO ACT SBD | File Type: | CO ACT SBD File
Data Element Name | Error/Warning Code | Error Type | Message | Status | Tier | Last Updated User | Last Updated Date
BIRTH_DATE_ACT | AC020 | Error | Birth Date must be unchanged from the vendor file for this COACT Record ID. | Active | 1
COACT_RECORD_NUMBER | AC016 | Error | COACT Record ID must be present in the vendor file | Active | 1
COACT_RECORD_NUMBER | AC026 | Error | Only one record may be submitted per COACT Record Number. | Active | 1
CONTINUOUSLY_ENROLLED_ACT | AC003 | Error | Continuously Enrolled ACT must be a valid code | Active | 1
EDUCATIONAL_PROGRAMS | AC009 | Error | Educational Programs must be a valid code | Active | 1
ELL_PROGRAM | AC006 | Error | ELL Program must be a valid code | Active | 1
FIRST_NAME_ACT | AC017 | Error | First Name must be unchanged from the vendor file for this COACT Record ID. | Active | 1
FREE_LUNCH_ACT | [NAME] | Error | Free/Reduced Lunch ACT must be a valid code | Active | 1
GENDER_ACT | AC021 | Error | Gender must be unchanged from the vendor file for this COACT Record ID. | Active | 1
GRADE_LEVEL_ACT | AC024 | Error | Grade Level ACT must be unchanged from the vendor file for this COACT Record ID. | Active | 1
GRADE_LEVEL_ACT | AC025 | Error | Only 11th grade students are eligible to take the CO ACT.  Please contact CDE to make changes to this field. | Active | 1
LANGUAGE_BACKGROUND_ACT | AC005 | Error | [NAME] ACT must be a valid code | Active | 1
LAST_NAME_ACT | AC018 | Error | Last Name must be unchanged from the vendor file for this COACT Record ID. | Active | 1
MIDDLE_NAME_ACT | AC019 | Error | Middle Name must be unchanged from the vendor file for this COACT Record ID. | Active | 1
MIGRANT_ACT | AC004 | Error | Migrant ACT must be a valid code | Active | 1
NEW_TO_SCHOOL_ACT | AC002 | Error | New To School ACT must be a valid code | Active | 1
PRIMARY_DISABILITY_ACT | AC007 | Error | Primary Disability ACT must be a valid code | Active | 1
RACE_ACT | AC012 | Error | Race/Ethnicity ACT must be a valid code | Active | 1
SASID | 99999 | Warning | The SASID is invalid or name, birth date, or gender doesnt match whats in the RITS system for the entered SASID | Active | 1
SCHOOL_CODE | AC001 | Error | School Code must be a valid code | Active | 1
SCHOOL_CODE | AC023 | Error | COACT HS Code must match its corresponding School Code | Active | 1
TESTED_STATUS_ACT | AC011 | Error | Tested Status ACT must be a valid code | Active | 1
TESTED_STATUS_ACT | [NAME] | Error | If a student is eligible to take an alternate assessment as determined by IEP team, then that student must have an IEP which is part of Value B-E. | Active | 1
TEST_ACCOMADATION_ACT | AC008 | Error | Test Accommodation ACT must be a valid code | Active | 1
TEST_LOCATION_ACT | AC022 | Error | Test Location must be unchanged from the vendor file for this COACT Record ID. | Active | 1
Spreadsheet: d81a1142-9673-4dc1-af23-ffe0eed6d482
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Transport
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Transportservice Lillestrøm AS | Prost Stabels v 8 | 2019 | Skedsmokorset | 64 83 03 96
Nordic Crane Kynningsrud AS | [NAME] | 1664 | Rolvsøy | 69 30 97 00 | 69 30 97 01
Royal Transport AS | Idrettsv. 122 | 5353 | [NAME] | 56 31 42 00 | 56 31 42 01
Bulk Tank Transport AS | Borgev. 7 | 3178 | Våle | 33 06 09 29
Eikerbud AS | Gressgangen 13 | 3300 | Hokksund | 928 61 453 | 32 80 11 59
[NAME] og Bærum AS | Rudssletta 90 | 1351 | Rud | 67 17 55 00 | 67 17 55 55
Forlaget Last og Buss AS | [NAME] g 98B | 0175 | Oslo | 23 23 47 50 | 22 38 38 12
DSV Solutions AS | [NAME]. 9 | 1405 | Langhus | 09870
[NAME] | [NAME] g 8 | 0154 | Oslo | 23 35 76 00 | 22 41 49 72
Leif Hodnemyr Transport | Odins g 10 | 4631 | Kristiansand | 38 09 08 04 | 38 09 78 15
Røes Transport AS | Soknedal | 7288 | Soknedal | 72 43 80 90 | 72 43 80 99
O S Transport | Hålandsv. 123 | 4360 | Varhaug | 986 24 982
Nortransport AS | Hansrudv. 8 | 2335 | Stange | 62 58 86 00 | 62 58 86 01
Transport-Formidlingen SA | [NAME] v 255 | 0976 | Oslo | 22 90 75 00 | 22 90 75 75
TNR [NAME] | Husøyv. 250 | 4262 | Avaldsnes | 52 70 05 00 | 52 70 05 02
Haanpaa AS | Titang. 7A | 1630 | Gamle Fredrikstad | 69 35 72 90 | 69 35 72 91
Haugerud Transport AS | Konnerudg. 2D | 3045 | Drammen | 957 06 548
Leverance AS | Elvev. 130 | 3271 | Larvik | 916 77 550 | 33 17 98 70
[NAME] | Holmestrandsv. 130C | 3036 | Drammen | 32 21 00 60 | 32 21 00 65
Grundekjøn Svend Transport | [NAME]. 181 | 4634 | Kristiansand | 907 69 704 | 38 11 38 00
Myrvollen Transport AS | [NAME] 20 | 3158 | Andebu | 951 99 470
[NAME] | Bruv. 8 | 7517 | Hell | 74 80 66 12 | 74 82 11 15
Hoff Svein Transportservice AS | Fleslandsv. 203 | 5258 | Blomsterdalen | 55 22 87 90
[NAME] | Jernbanetorget 2 | 0154 | Oslo | 02010
Etnedal Bilruter AS | Etnedalsv. 1622 | 2890 | Etnedal | 61 12 14 00
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: cafdaf0d-d9dd-4667-b7ae-ad1b67fe5479
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
7983 | 10329 | Curt | Maier | AUT | 181 | 00:29:17 | 00:00:00 | [NAME] | 00:00:00 | 00:40:47 | 1 | 01:41:54
Spreadsheet: 79199d1279491008-excel-2007-how-to-make-this-conditional-equation-book1
Sheet: Sheet1

 |  |  | Rules |  |  |  |  |  | C2 > * or /
 |  | 2 | 12 | 1 to 5 | If C2 | [NAME]6 |  | 1 | 6
 |  | 7 | 28 | 6 to 9 | If [NAME] | [NAME] |  | 6 | 4
 |  | 11 | 22 | 10 to 15 | If C4 | [NAME] |  | 10 | 2
 |  | 16 | 24 | 16 to 25 | If C5 | [NAME]1.5 |  | 16 | 1.5
 |  | 29 | 29 | 26 to 50 | If C6 | [NAME] |  | 26 | 1
 |  | 60 | 17.14285714285714 | 51 to 75 | If C8 | D2= C2/2 |  | 51 | 0.5
 |  | 90 | 36 | 76 to 90 | If C9 | D2= C2/2.5 |  | 76 | 0.4
 |  | 93 | 26.57142857142857 | 91 to 110 | If [NAME] | D2= C2/3 |  | 91 | 0.3333333333333333
 |  | 125 | 35.71428571428572 | 111 to 130=/3;5 | If C11 | D2= C2/3.5 |  | 11 | 0.2857142857142857
 |  | 132 | 33 | 131 to 150=/4 | If C12 | D2= C2/4 |  | 131 | 0.25
 |  | 160 | 35.55555555555556 | 151 to 175=/4;5 | If [NAME] | [NAME] |  | 151 | 0.2222222222222222
 |  | 200 | 36.36363636363637 | 176 to 210=/5;5 | If [NAME] | D2= C2/5.5 |  | 176 | 0.1818181818181818
 |  | 245 | 37.69230769230769 | 211 to 250=/6;5 | If C15 | [NAME] |  | 211 | 0.1538461538461539
 |  | 266 | 35.46666666666667 | 251 to 290=/7;5 | If [NAME] | [NAME] |  | 251 | 0.1333333333333333
 |  | 300 | 35.29411764705883 | 291 to 320=/8;5 | If C17 | D2= C2/8.5 |  | 291 | 0.1176470588235294
 |  | 359 | 36.63265306122449 | 321 to 360=/9;8 | If C18 | D2= C2/9.8 |  | 321 | 0.1020408163265306
Spreadsheet: tracy_geaccone__40285__EMNNG01CE
Sheet: OtherInc

PRINT: PRINT
 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
PARTNERSHIP INCOME
Trailblazer
Overthrust |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other (4/01-Imbalance Adj. / 12/01-FAS 125 Adj.) |  | 0 | 0 | 0 | 952 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL PARTNERSHIP INCOME | [NAME]
INTEREST INCOME
Interest Income - Racom Only
- Other Miscellaneous
Carrying Charges - Order 528 (Misc. Item 1) | Linked
- Stranded 858 R.A. ([NAME]. Item 2 | Linked
- GSR  ([NAME]. Item 3) | Linked
- Kansas Ad Valorem Tax Issue | Linked
Other
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL INTEREST INCOME
OTHER
Misc. Non-Operating Income - CIAC   "FA&A Function"
AFUDC Equity Grossup              "FA&A Function" | Link D.T.
AFUDC Equity Grossup Amort.   "FA&A Function" | Link D.T.
Asset Sales - Mops $8.8 (Was April Now Dec.) | Link D.T.
- Seagull (2000 Item $1.1 in Plan)/East Leg (Dec) | Link D.T.
- Gomez (6/01-Sold 5/31/01) / Other | Link D.T.
Speculative Income / (Loss)       "Commercial Function"
Swap 2                                 "Commercial Function"
Swap 3                                 "Commercial Function"
Pipeline Capacity & Annual Fee   "Commercial Function"
Other Gains / (Losses)       "Commercial Function"
Miscellaneous                   "Commercial Function"
Pr.Yr. Base Gas Sale Adj. (7/01)   "Commercial Function"
Misc. Item 2                     "Commercial Function"
Misc. Item 3                     "Commercial Function"
Misc. Item 4                     "Commercial Function"
Physical Inventory Gains / (Losses)     "Operations Function"
Net Income Adjustment (To Tie Annual Total Back to 1st CE) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL OTHER
TOTAL OTHER INCOME
Spreadsheet: 149075d1333678674-need-to-pull-multiple-reference-points-into-one-spread-sheet-kit-20report-20draft-1-
Sheet: YTD TOTALS

FY12 TOTALS | FORECAST QTY | CHANGE TO FORECAST QTY |  | DATE OF CHANGE | CHANGE VS FORECASTEDQTY |  | REQUESTED QUANTITY |  | PULL REQUEST EST. SUCCESS RATE |  | LINE SET UP EST SUCCESS RATE |  | EST. ASSEMBLY START DATE SUCCESS RATE | EST. ASSEMBLY COMPLETION DATE SUCCESS RATE |  | YTD ASSEMBLED QUANTITY |  | YTD SHIPPED QUANTITY |  | YTD SHIPPED VS FORECASTEDQUANTITY |  | YTD SHIPPED VS FORECASTED %
Toric & Multifocal
PCT84108X |  | 0
PCT108X |  | 0
PCT84324X |  | 0
PCT324X |  | 0
PCMF324NX |  | 0
PCMF10825X |  | 0
BFTRC520X |  | 0
BFTRC460X |  | 0
BFTRC780X |  | 0
BFMF520X |  | 0
AVTRC780X |  | 0
AVTRC520X |  | 0
BT324X |  | 0
BT108X |  | 0
Dailies
CS1D1200X | 50 | 0
EQ1D1200X | 2500 | 0
CS1DT400X | 98 | 0
PC1D1200X | 803 | 0
PC1DMF600X | 0 | 0
Sphere
PCC60 | 100 | 0
EP6060X | 64 | 0
Biofinity207X | 475 | 0
F55A60 | 0 | 0
XC60X | 30 | 0
55UVASPHX | 16 | 0
AVAIRA207X | 650 | 0
Canada
Toric & Multifocal
PCT84CAN324X | 4 | 0
PCTCAN324X | 1 | 0
PCMFCAN324NX | 14 | 0
BFTRCCAN780X | 60 | 0
ENTRCCAN780X | 100 | 0
BFMFCAN520X | 125 | 0
Dailies
BIOMEDICS52CAN1200X | 10 | 0
PC1DCAN1080X | 24 | 0
PC1DCAN1200X | 0 | 0
BIOMEDICS1DTCAN400X | 5 | 0
PC1DMFCAN600X | 0 | 0
Sphere
PCCCAN180X | 4 | 0
55SPHCAN186X | 0 | 0
EP60CAN180X | 5 | 0
BIOFINITYCAN207X | 17 | 0
[NAME]
ENC100CAN207X | 30 | 0
Spreadsheet: 718681d1613296355-count-function-for-dates-month-and-year-and-text-count-date-and-text-eg2
Sheet: Sheet1

Example
[NAME] |  |  |  |  | [NAME]
 |  |  |  |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
Date Raised | Status | Classification |  | No of Events Raised
2021-01-01 00:00:00 | Open | Minor |  | Events Open
2021-01-05 00:00:00 | Closed | Major |  | Events Closed
2021-02-10 00:00:00 | In-Progress | Major |  | Minor | 2
2021-04-15 00:00:00 | Open | Major |  | Major | 1
2020-01-21 00:00:00 | Open | Minor |  | Using the previous concept of searching for open event per month searchig by status, I also need to add to that using coloum "C" to determine which of those same record have either a Major or minor classification.   [NAME] required in F7 & 8 respectively for each month.
2021-01-31 00:00:00 | Closed | Major
2021-07-14 00:00:00 | Open | Major
2021-01-03 00:00:00 | open | Minor
2021-01-05 00:00:00 | open | Major
Spreadsheet: 477563d1472373025-lookup-or-index-match-excelforum-1
Sheet: Sheet1

Company | Rank | Name |  | Company | Dragon's Hotel
Abacus PLC | CEO | Samanmali |  | Rank | Labor
Abacus PLC | Manager | Sisira |  | Name
Abacus PLC | [NAME] | [NAME]
Abacus PLC | Labor | Upul
Bambi Inc | CEO | Bandara |  | Abacus PLC
Bambi Inc | Manager | [NAME] |  | Bambi Inc
Bambi Inc | [NAME] | Keerthi |  | Comodo café
Bambi Inc | Labor | [NAME] |  | Dragon's Hotel
Comodo café | CEO | Kanishka
Comodo café | Manager | Niroshan |  | CEO
Comodo café | [NAME] | Samarathunga |  | Manager
Comodo café | Labor | Shantha |  | [NAME]
Dragon's Hotel | CEO | Yoga |  | Labor
Dragon's Hotel | Manager | Weeralal
Dragon's Hotel | [NAME] | Lindara
Dragon's Hotel | Labor | [NAME]
Spreadsheet: 829758d1684425122-need-to-add-cells-j9-j16-for-all-icoy-working-capital-inside-ifna-formula-feb23-trial-balances-lse-test
Sheet: 111001 - 200102

[NAME]
TB Account |  |  |  |  | TB Account
As of | 2023-01-31 00:00:00 |  |  |  | As of | 2023-01-31 00:00:00
Prior Period |  |  |  |  | Prior Period
Ending Balance |  |  |  |  | Ending Balance
Current Period |  |  |  |  | Current Period
Units Recorded
Unit Number | Contract Price | Allocated Forecast | Selling Cost
1106 | 1170000 | -1072888.5 | -59438
3605 | 545000 | -499764.3 | -28893
Total
IM Accrual Reconcilaitons
Unit Number | Contract Price | Allocated Forecast | Selling Cost
Prior Period Reconcilaitons
Unit Number | Contract Price | Allocated Forecast | Selling Cost | Prior Entry | [NAME] Booked
Total
 | Total | Variance to TB
Total Contract Price
[NAME]
Spreadsheet: jeff_dasovich__14065__m010501
Sheet: SCE purchase estimate

 | SCE PURCHASES BY DWR
Year | 2001 | 2002
Spot (MWH)
Rate | 275 | 135
Spot $'s
[NAME] (MWH)
Rate (average 5 year) | 90 | 90
Long Term $'s
Total SCE purchases by DWR
Total 2001 & 2002
Spreadsheet: 94598d1294362170-highlighting-a-row-from-drop-down-selection-fault-issues-
Sheet: LYNX

 | QUOTE NUMBER | DATE REPORTED | TIME REPORTED | FAULT TYPE | FAULT DETAILS | PRIORITY | STATUS | DATE RESOLVED | TIME RESOLVED | RELEVANT FILES | CONTACT
 | 1 | 2010-10-12 00:00:00 | N/A | Out of sequence | Data out of sequence | MEDIUM | Closed | 2011-01-07 00:00:00 | 2011-01-07 08:48:02 | Data out of sequence - 12.10.10 | [NAME] |  |  |  |  |  |  |  |  |  |  | ..\EM80
 | 2 | 2010-10-13 00:00:00 | N/A | System boot out |  | HIGH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ..\FMECA
 |  | 2010-10-14 00:00:00 | N/A | Hardware |  | HIGH | Closed | 2011-01-07 00:00:00 | 2011-01-07 08:48:02 |  |  |  |  |  |  |  |  |  |  |  |  | ..\VI system developments
 |  | 2010-10-18 00:00:00 | N/A | Irretrievable images |  | MEDIUM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ..\Video Imaging System
 |  | 2010-10-18 00:00:00 | N/A | Other |  | HIGH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ..\Work Files
 |  | 2010-10-20 00:00:00 | N/A | Data drop offs |  | HIGH
 |  | 2010-10-27 00:00:00 | N/A | Data drop offs |  | HIGH
 |  | 2010-10-28 00:00:00 | N/A | Data drop offs |  | MEDIUM
 |  | 2010-11-06 00:00:00 | 13:31 PM | Irretrievable images |  | MEDIUM
 |  | 2010-11-12 00:00:00 | 07:14:00 | Out of sequence |  | MEDIUM
 |  | 2010-11-12 00:00:00 | 08:17:00 | Irretrievable images |  | HIGH
 |  | 2010-11-13 00:00:00 | 10:57:00 | Incorrect Flagging |  | HIGH
 |  | 2010-11-20 00:00:00 | 09:10:00 | Out of sequence |  | MEDIUM
 |  | 2010-11-21 00:00:00 | 06:50:00 | Out of sequence |  | HIGH
 |  | 2010-11-27 00:00:00 | 06:16:00 | Data drop offs |  | HIGH
 |  | 2010-12-22 00:00:00 | 14:07:00 | Incorrect Flagging |  | HIGH
 |  | 2010-12-28 00:00:00 | 17:25:00 | Hardware |  | HIGH
 |  | 2010-12-30 00:00:00 | 14:46:00 | Hardware |  | HIGH
Spreadsheet: 846000d1697295962-xlookup-from-table-where-the-looked-up-columns-may-move-example-spreadsheet-after-update-2-
Sheet: Sheet1

Status | Customer | Country | [NAME] | Age | Sex | Weight (kg) | Decision Date | Units | Last Shipment
Open | Customer A | United Kingdom | AAA1 | 64 | Male | 82 | 2022-08-30 00:00:00 | 345 | 2023-03-21 00:00:00
Open | Customer A | United Kingdom | AAA2 | 65 | Female | 100 | 2022-09-14 00:00:00 | 43 | 2023-06-22 00:00:00 |  | [NAME] | Decision Date
Open | Customer B | United Kingdom | AAA3 | 53 | Female | 63 | 2022-10-12 00:00:00 | 23 | 2023-06-20 00:00:00 |  | AAA4
Open | Customer B | United Kingdom | AAA4 | 43 | Female | 81 | 2022-10-12 00:00:00 | 12 | 2023-07-24 00:00:00
Open | Customer C | United Kingdom | AAA5 | 76 | Female | 102 | 2022-10-25 00:00:00 | 43 | 2023-07-24 00:00:00
Open | Customer C | United Kingdom | AAA6 | 45 | Female | 62 | 2022-11-04 00:00:00 | 123 | 2023-07-12 00:00:00
Open | Customer C | United Kingdom | AAA7 | 43 | Male | 86 | 2022-11-04 00:00:00 | 12 | 2023-07-10 00:00:00
The above table is a simplifed version of the actual table which has many more row and columns.
1. I want to lookup Person from cell [NAME] (currently person AAA4)
2. I want to bring back the Decision Date for that person in cell M4
3. This works if the columns do not move BUT….
4. Each week, data is copied from another table and pasted as values into this table. The two tables cannnot be linked with formulas due to access rights and data sensitivity.
5. Sometimes, the position of the columns may be altered in the table we copy data from. Due to the number of columns it is difficult to notice this before copying across.
6. I need the formula in cell M4 to capture the Decision Date for the Lookup Person regardless of where the columns of Person ID and Decision Date are in the table.
7. As an example, if the data from the table in columns O to X was copied as pasted as values into the table in columns A to J, the formula in cell M4 should still bring back the date of 12th October '22.
Any help much appreciated!
Spreadsheet: 126299d1319624249-issue-with-setting-up-a-formula-with-more-than-one-condition-ge-report-august-2011-final-test
Sheet: Paris 2011

PARIS
GE Business | GE Sub-business | Matter Number | Matter Description | GE Contact | Office | S&S Contact | Status | Category of Work | Non S&S related sums billed from 01 January to 31 August 2011 (£) | S&S related sums billed from 01 January to 31 August 2011 (£) | Cumulative Total 2011 (£)
Healthcare | GE Healthcare UK Limited | 67710-1 | GE Healthcare Lottery | [NAME] | London | [NAME] | Nothing at present | 5 | 0 | 0 | 0
Industrial | Granite Services Inc | 64209-12 | Employment advice | Monta Bolles | Paris | [NAME] | Ongoing | 6 | 0 | 5356.75 | 5356.75
NBC Universal | Global Networks | 60441-1 | General Employment Advice | [NAME] | Paris | [NAME] | On hold | 6 | 0 | 0 | 0
NBC Universal | Universal Pictures Video (France) SAS | 57007-2 | Conseil en droit social | Stéphanie Bessis | Paris | [NAME] | On hold | 6 | 0 | 0 | 0
NBC Universal | Universal TV France SNC | 73828-1 | French employment | [NAME] | Paris | [NAME] | Ongoing | 6 | 0 | 1676.74 | 1676.74
NBC Universal | Global Networks Management Limited | 60441-2 | Employment law advice | Youatt, [NAME] | Paris | [NAME] | On hold | 6 | 0 | 5259.61 | 5259.61
Commercial Finance | GE Capital Solutions Europe Ltd | 22548-15 | [NAME]. employment advice | [NAME] Maunder | Paris | [NAME] | On hold | 1 | 0 | 0 | 0
Totals for Paris: |  |  |  |  |  |  |  |  | 0 | 12293.1 | 12293.1
Spreadsheet: 696268d1600736923-collating-multiple-tab-info-into-one-rj-projections_chrispq
Sheet: Totals

Totals |  |  |  |  |  |  |  | Payment Dates
Supplier | Forecast Month | [NAME] (Product) | [NAME] (Number) | Container Number | Time to arrive (M) | Order Date | Container Cost (£) | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
 | In date order and
 | then supplier order