tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 677969d1589639745-power-query-extract-data-from-cells-to-build-a-table-of-data-for-analysis-book3
Sheet: 02

REPORT 02
02.01.2020
SECTION 1
Executive Summary |  |  | A | Monitor IT and staff security
Executive Summary |  |  | A | Level III Sys Ops Managers & Operators
SECTION 2
Issue |  | Description |  |  |  |  |  | Status
1 |  | A.16.1.4 Assessment of decision on security events |  |  |  |  |  | A
2 |  | A.16.1.5 Response to information security incidents |  |  |  |  |  | A
3 |  | A.17.2.1 Availability of information processing equipment |  |  |  |  |  | G
SECTION 3
 | Description
 |  |  |  |  | For info | For action
1 | ITIL accrediation |  |  |  | Director | SSO
SECTION 4 |  |  |  |  |  |  | Status
The first (top) category includes foundational information such as concepts, models and terminology. |  |  |  |  |  |  | G
2. How the document is referenced |  |  |  |  |  |  | A
3. Reuse of the terms and definitions in ISO/IEC 27000 |  |  |  |  |  |  | A
The ISASecure scheme requires that all products are properly tested during the supplier development process in conformance to ANSI/ISA 62443-4-1. |  |  |  |  |  |  | G
SECTION 5
A.5 Security Policy v2
A.6 Organisation of information Security - Jan 2020
SECTION 6
A.7 Asset Management & IT
A.8 Human Resources
A.9 Physical and environmental security.  Policy
SECTION 7
A.10 Operations management
A.11 Access Control SS Policy
A.12 Information systems acquisition, development and maintenance
A.13 Information security incident management
SECTION 8
ISO/IEC JTC 1/SWG 6, Management
ISO/IEC JTC 1/WG 7, Sensor networks
ISO/IEC JTC 1/WG 9, Big Data
ISO/IEC JTC 1/WG 10, Internet of Things (IoT) - Jan 2021
SECTION 9
Recommendation 1 | ISO/IEC JTC 1/SC 27/SWG-M | Status | A
ISO/TC 8, Ships and marine technology
ISO/TC 46, Information and documentation
ISO/TC 46/SC 11, Archives/records management
ISO/TC 68, Financial services
ISO/TC 68/SC 2, Financial Services, security
Recommendation 2 | ISO/IEC JTC 1/SC 27/WG 1 | Status | G
ISO/TC 8, Ships and marine technology & Events
ISO/TC 46, Information and documentation
ISO/TC 46/SC 11, Archives/records management
ISO/TC 68, Financial services
ISO/TC 68/SC 2, Financial Services, security
ISO/TC 68/SC 7, Core banking & Facilities
ISO/TC 171, Document management applications
ISO/TC 176, Quality management and quality assurance
ISO/TC 176/SC 3, Supporting technologies
Recommendation 3 | ISO/IEC JTC 1/SC 27/WG 3 | Status | A
ISO/TC 272, Forensic sciences Dept
ISO/TC 292, Security and resilience
ISO/CASCO, Committee on Conformity Assessments
ISO/TMB/JTCG, Joint technical Coordination Group on MSS
ISO/TMB/SAG EE 1, Strategic Advisory Group on Energy Efficiency
IEC/SC 45A, Instrumentation, control and electrical systems of chemcial facilities
IEC/TC 57, Power systems management and associated information exchange
IEC/TC 65, Industrial-process measurement, control and automation
IEC Advisory Committee on Information security and data privacy (ACSEC)
Spreadsheet: 98501d1297366374-multiply-countif-by-criteria-in-same-row-sample-book
Sheet: Sheet1

Customer | Code | Code | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun |  | Code | Qty | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
cust 1 | Code 1 | Code A | No | No | No | No | No | No | No
cust 2 | Code 2 | Code B | No | No | No | No | No | No | No
cust 3 | Code 3 | Code C | No | No | No | No | No | No | No
cust 4 | Code 4/1K | Code D | Yes | No | No | Yes | No | No | No
cust 5 | Code 2 | Code C | No | No | No | No | No | No | No
cust 6 | Code 3 | Code A | No | No | No | No | No | No | No |  | Twice Weekly Delivery
cust 7 | Code 2 | Code C | No | No | No | No | No | No | No |  | Code | [NAME] | Fri
cust 8 | Code 1/1K | Code A | Yes | No | No | Yes | No | No | No |  | Code 1
cust 9 | Code 3 | Code C | No | No | No | No | No | No | No |  | Code 2
cust 10 | Code 2 | Code B | No | No | No | No | No | No | No |  | Code 3
cust 11 | Code 4 | Code A | No | No | No | No | No | No | No |  | Code 4
 |  |  |  |  |  |  |  |  |  |  | Alphabetic Codes
 |  |  |  |  |  |  |  |  |  |  | Code | Qty | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Spreadsheet: 854228d1704186165-formula-to-sum-the-prices-of-repeated-serial-numbers-toforum
Sheet: Sheet2

serial | price | total
1 | 20.5 | 42.5
1 | 12
1 | 10
2 | 62 | 76
2 | 14
3 | 18 | 18
4 | 20.5 | 60.5
4 | 19.5
4 | 12
4 | 8.5
Spreadsheet: 861197d1709139797-xlookup-formula-for-multiple-lookup-value-in-same-cell-separated-by-xlookup-for-value-separated-by-slash
Sheet: ORDER NUMBER

SL# | Order Number | PO NUMBER
1 | T224M0001
2 | T224M0002
3 | T224M0003
4 | T224M0003
5 | T224M0006
6 | T224M0007
7 | T224M0008
8 | [NAME]
9 | T224M0011
10 | T224M0015
11 | T224M0016
12 | T224M0017
13 | T224M0018
14 | T224M0019
15 | T224M0020
16 | T224M0004
17 | T224M0009
18 | T224M0012
19 | T224M0005
20 | T224M0014
21 | T224M0013
Spreadsheet: 767842d1644672003-how-to-calculate-accessories-left-with-formula-stock
Sheet: Sheet1

IN STOCK |  |  |  | GIVEN TO USERS
Date | Item | Qty |  | Given Date | User | Item | Qty | Left in stock | Expected Result
2022-02-01 00:00:00 | Earpods | 30 |  | 2022-01-01 00:00:00 | [NAME] | Earpods | 2
2022-02-01 00:00:00 | HDMI Cable | 50 |  | 2022-01-02 00:00:00 | [NAME] | HDMI Cable | 4
 |  |  |  | 2022-02-01 00:00:00 | User | Earpods | 1 |  | 29
 |  |  |  | 2022-02-05 00:00:00 | User | HDMI Cable | 5 |  | 45
 |  |  |  | 2022-02-06 00:00:00 | dada | Earpods | 20 |  | 9
Calculate only if the given date in E:E is the same or above as column A:A
Spreadsheet: 799761d1665256722-exclude-columns-that-match-other-columns-excel-question
Sheet: Sheet1

Datas |  |  | Criterias to exclude |  |  | FORMULA | For each year, excluse all datas from columns B and C that are identical to columns D and E respectively AND ignore all datas that are blank. Then write down all Datas remaining without blank lines in between.
2017 | 13 | (Fx)
2017 | 8 | (E) |  |  |  | Results looking to achieve: |  |  | 2017 | 13 | (Fx)
2017 | 12 | (E) |  |  |  |  |  |  | 2017 | 12s | (E)
2017 | 12s | (E) |  |  |  |  |  |  | 2017 | 46 | (E)
2017 | 46 | (E) |  |  |  |  |  |  | 2017 | 50 | (E)
2017 | 50 | (E) |  |  |  |  |  |  | 2017 | 8 | ([NAME])
2017 | 8 | ([NAME]) |  |  |  |  |  |  | 2018 | 8 | (E)
2017 |  |  | 8 | (E) |  |  |  |  | 2018 | 12 | (E)
2017 |  |  | 12 | (E) |  |  |  |  | 2018 | 12s | (E)
2018 | 13 | (Fx) |  |  |  |  |  |  | 2019 | 13 | (Fx)
2018 | 8 | (E) |  |  |  |  |  |  | 2019 | 12 | (E)
2018 | 12 | (E)
2018 | 12s | (E)
2018 | 46 | (E)
2018 | 50 | (E)
2018 | 8 | ([NAME])
2018 | 13 | ([NAME])
2018 |  |  | 13 | (Fx)
2018 |  |  | 46 | (E)
2018 |  |  | 50 | (E)
2018 |  |  | 8 | ([NAME])
2018 |  |  | 13 | ([NAME])
2019 | 13 | (Fx)
2019 | 8 | (E)
2019 | 12 | (E)
2019 | 50 | (E)
2019 | 8 | ([NAME])
2019
2019
2019
2019 |  |  | 8 | (E)
2019 |  |  | 50 | (E)
2019 |  |  | 8 | ([NAME])
2020 and up, etc..
Spreadsheet: 752649d1634881094-help-to-create-an-order-list-based-on-products-by-cheapest-supplier-price-comparison-test-1-
Sheet: Template

Product | Supplier | Price | Quantity | Unit Price | Date | % change | Notes |  | PRODUCT | SUPPLIER | PRICE |  | CHEAPEST PRICE | FROM
Chit Chat Coffee | Mr Duffin | 15.8 | 66 |  |  |  |  |  | [NAME]
Chit Chat Retail Coffee | Mr Duffin | 4.3 | 1
Chit Chat Decaf Coffee | Mr Duffin | 17.5 | 66
Pimms | Booker | 10.99 | 1
Baileys | Booker | 10.99 | 1
Coke BIB | Booker | 61.99 | 1
Diet Coke BIB | Booker | 51.99 | 1
Ginger Beer | Booker | 10.99 | 12
Old Mout Berries & Cherries | Booker | 16.19 | 12
Old Mout Kiwi & Lime | Booker | 16.19 | 12
Peroni | Booker | 20.99 | 24
Shipyard American IPA | Booker | 10.49 | 8
Wyldwood Organic Cider | Booker | 9.99 | 10
Scweppes BIB | Booker | 58.99 | 1
Strathmore Still Mineral Water | Booker | 6.85 | 24
Strathmore Sparkling Mineral Water | Booker | 6.39 | 24
Prosecco Spumante | Booker | 24.99 | 12 |  |  |  |  |  | PRODUCT | SUPPLIER | PRICE | DATE CHECK | Difference | NOTES
Cawston Press Apple Juice | Suma | 11.7 | 6
Cawston Press Apple & Elderflower | Suma | 11.7 | 6
[NAME] | Booker | 18.99 | 1040
[NAME] | JMP | 21.88 | 1040
Orange Syrup | Next Day Coffee | 6.69 | 1
[NAME] | Next Day Coffee | 6.69 | 1
[NAME] | Next Day Coffee | 6.69 | 1
[NAME] | Next Day Coffee | 6.69 | 1
[NAME] | Next Day Coffee | 6.69 | 1
[NAME] | Next Day Coffee | 6.69 | 1
Fine Lakeland Tea (1kg) | Penningtons | 18.5 | 1000
Decaf Tea | Penningtons | 3.45 | 40
[NAME] | Penningtons | 4.15
Kendal Mint Cake Tea | Penningtons | 4.15
Apple & Lemon Tea | Penningtons | 4.15
Passionfriut & Orange | Penningtons | 4.15
[NAME] | Penningtons | 3.75 | 40
Sugar Sticks White | Penningtons | 10.6 | 1000
Sugar Sticks Brown | Penningtons | 11.45 | 1000
[NAME] | Penningtons | 8.7 | 1
Twinings Peppermint Tea | JMP | 2.02 | 20
Twinings Lemon & Ginger Tea | JMP | 2.02 | 20
Twinings Green Tea | JMP | 2.02 | 20
[NAME] | Next Day Coffee | 27.99 | 1040
Spreadsheet: 680373d1590995671-google-sheets-countifs-multiple-criteria-from-multiple-sheets-2020-05-31-oeldere-wlinksanju-680369d1590992057-countifs-multiple-criteria-from-multiple-shee
Sheet: year

date | Staff name | Kolom1 | customer | Feedback | year | month
2020-01-01 00:00:00 | raju |  | raj | wants to renew
2020-01-01 00:00:00 | sanju |  | hari | out of city |  |  |  |  |  | Aantal van Feedback | Kolomlabels
2020-01-02 00:00:00 | sanju |  | [NAME] | wrong number |  |  |  |  |  | Rijlabels | out of city | wants to renew | wrong number | Eindtotaal
2020-01-03 00:00:00 | sanju |  | sking | wrong number |  |  |  |  |  | raju |  | 1 |  | 1
2020-01-04 00:00:00 | siru |  | yking | wrong number |  |  |  |  |  | 1 |  | 1 |  | 1
2020-01-05 00:00:00 | sannu |  | zking | wants to renew |  |  |  |  |  | sanju | 3 | 5 | 9 | 17
2020-01-06 00:00:00 | sanju |  | rraj | wrong number |  |  |  |  |  | 1 | 1 | 1 | 3 | 5
2020-01-01 00:00:00 | sanju |  | yraj | wants to renew |  |  |  |  |  | 2 | 1 | 2 | 3 | 6
2020-02-01 00:00:00 | sanju |  | raj | wants to renew |  |  |  |  |  | 3 | 1 | 2 | 3 | 6
2020-02-01 00:00:00 | sanju |  | hari | out of city |  |  |  |  |  | sannu |  | 3 |  | 3
2020-02-02 00:00:00 | sanju |  | [NAME] | wrong number |  |  |  |  |  | 1 |  | 1 |  | 1
2020-02-03 00:00:00 | sanju |  | sking | wrong number |  |  |  |  |  | 2 |  | 1 |  | 1
2020-02-04 00:00:00 | siru |  | yking | wrong number |  |  |  |  |  | 3 |  | 1 |  | 1
2020-02-05 00:00:00 | sannu |  | zking | wants to renew |  |  |  |  |  | siru |  |  | 3 | 3
2020-02-02 00:00:00 | sanju |  | rraj | wrong number |  |  |  |  |  | 1 |  |  | 1 | 1
2020-02-01 00:00:00 | sanju |  | yraj | wants to renew |  |  |  |  |  | 2 |  |  | 1 | 1
2020-03-01 00:00:00 | sanju |  | raj | wants to renew |  |  |  |  |  | 3 |  |  | 1 | 1
2020-03-01 00:00:00 | sanju |  | hari | out of city |  |  |  |  |  | Eindtotaal | 3 | 9 | 12 | 24
2020-03-01 00:00:00 | sanju |  | [NAME] | wrong number
2020-03-02 00:00:00 | sanju |  | sking | wrong number
2020-03-03 00:00:00 | siru |  | yking | wrong number
2020-03-04 00:00:00 | sannu |  | zking | wants to renew
2020-03-05 00:00:00 | sanju |  | rraj | wrong number
2020-03-03 00:00:00 | sanju |  | yraj | wants to renew
Spreadsheet: 97801d1296868737-excel-2007-how-to-add-next-column-value-for-consecutive-patterns-test
Sheet: Sheet1

 | code | value |  |  |  | Manual calculation |  |  | Auto calculation
 | 1 | 2 |  |  |  | value  of [NAME] of code 0 | =-6
 | 0 | 3
 | 1 | 3 |  |  |  | Value of [NAME] of code 1 | =11.2 | (not 9)
 | 1 | 1
 | 1 | 2
 | 1 | 3.1
 | 0 | 4
 | 0 | 4
 | 1 | 2
 | 0 | -1
 | 0 | -2
 | 0 | -3
 | 1 | 2.2
 | 1 | 4
 | 1 | 4
 | 1 | 1
Spreadsheet: 866563d1713471833-vat-calculation-product-list_2
Sheet: TXNS

I'm kindly requesting a formula to calculate VAT using the information on the product list worksheet.
Description |  |  |  | Qty | Price | VAT | Total (exc VAT) | Total (incl VAT)
Bottled Water |  |  |  | 2
Coke |  |  |  | 3
Fertiliser |  |  |  | 6
Heater |  |  |  | 3
Screwdrive |  |  |  | 2
Spreadsheet: 68525d1269036571-calculating-data-from-multiple-worksheets-scratch
Sheet: Recipes

 |  | 824 | 237 | 41 | 44 | 259 | 361 | 210 | 42 | 108 | 5.4
Type of Cookie | Qty | [NAME] | Eggs | Baking Soda | Vanilla | Brown Sugar | White Sugar | Butter | [NAME] | Chocolate Chips | Cinnamon
Chocolate Chip | 9 | 35 | 9 | 2 | 2 | 13 | 10 | 7 |  | 12
[NAME] | 7 | 28 | 7 | 1 | 1 | 10 | 13 | 4 | 6
Short Bread | 3 | 19 | 9 | 2 | 1 |  | 12 | 15
Snicker-Doodles | 6 | 30 | 10 | 1 | 2 | 12 | 12 | 9 |  |  | 0.9
Sugar Cookies | 4 | 19 | 5 | 1 | 1 |  | 18 | 5
 |  |  |  |  |  |  |  |  |  |  |  | < add items as desired; table is dynamic
Spreadsheet: john_griffith__16164__1_28_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO G2 | 54 | 100 | 200 | 43 | 60 | 1.72 | 2002-01-25 15:07:00
 | [NAME] | 54 | 550 | 650 | 46.2 | 54.6 | 1.71 | 2002-01-28 10:34:00
 | HO J2 | 54 | 800 | 900 | 47.7 | 53.7 | 1.72 | 2002-01-28 10:34:00
 | HO K2 | 55 | 950 | 1050 | 44.8 | 49.6 | 1.63 | 2002-01-28 10:34:00
 | HO M2 | 55 | 1050 | 1150 | 42.4 | 46.4 | 1.54 | 2002-01-28 10:34:00
 | HO N2 | 55 | 1140 | 1240 | 41.6 | 45.3 | 1.5 | 2002-01-28 10:34:00
 | HO Q2 | 56 | 1200 | 1300 | 39.2 | 42.5 | 1.44 | 2002-01-28 10:34:00
 | HO U2 | 57 | 1275 | 1375 | 37.9 | 40.9 | 1.41 | 2002-01-28 10:34:00
 | [NAME] | 57 | 1350 | 1475 | 37.8 | 41.3 | 1.42 | 2002-01-28 10:34:00
 | HO X2 | 58 | 1375 | 1500 | 35.6 | 38.9 | 1.36 | 2002-01-28 10:34:00
 | [NAME] | 59 | 1450 | 1600 | 35.3 | 39 | 1.38 | 2002-01-28 10:34:00
 | HO F3 | 60 | 1500 | 1650 | 34.4 | 37.9 | 1.36 | 2002-01-28 10:34:00
 | [NAME] |  |  |  | 33.2 | 36.5 | 1.31 | 2001-12-31 13:18:00
 | HO H3
 | HO J3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: 777301d1650303743-compare-and-copy-to-new-collumn-example
Sheet: Sheet1

Offer No1 |  |  |  |  |  |  | Offer No2
Part no | Name | Price |  |  |  |  | Part no | Name | Price
101 | [NAME] | 0.1 |  |  |  |  | 101 | [NAME]
102 | Nut | 0.1 |  |  |  |  | 202 | Valve
103 | Hexagon | 0.5 |  |  |  |  | 102 | Nut
104 | Screw | 0.15 |  |  |  |  | 2002 | Screwdiver
105 | Bolt & Nut | 0.2 |  |  |  |  | 105 | Bolt & Nut
106 | [NAME] | 0.8 |  |  |  |  | 106 | [NAME]
 |  |  |  |  |  |  | 1080 | Valve
Spreadsheet: 145834d1331759610-excel-count-dublicate-text-how-find_duplicates
Sheet: Sheet1

Numbers | Market | Dup? | Count | Number of duplicates | [NAME]
1 | Market 1 | 0 | 1
0 | Market 2 | 0 | 1
0 | Market 3 | 0 | 1
1 | Market 4 | 0 | 1
0 | Market 6 | 1 | 2 | 2 | Market 6
1 | Market 6 | 0 | 0
Spreadsheet: 823742d1680118586-index-match-across-multiple-sheets-w-multi-row-answer-indexmatch-multi-row2
Sheet: people

NAME | AET | GROUP | [NAME]
Person1 | ONE | CSG | 5 | 6 | 7 | 8 | 9 | 10
Person2 | TWO | CSG | 8 | 9 | 10
Person3 | THREE | CSG | 8 | 9 | 10
Person4 | FOUR | CSG | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Person5 | FIVE | MAP | 10 | 11 | 12
Person6 | SIX | MAP | 10 | 11 | 12
Person7 | SEVEN | MAP | 10 | 11 | 12
Person8 | EIGHT | MAP | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
Person9 | NINE | MAP | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Person10 | TEN | MAP | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Person11 | ELEVEN | MAP | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Person12 | TWELVE | MAP | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
[NAME] | THIRTEEN | MAP | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Person14 | FOURTEEN | MAP | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Person15 | FIFTEEN | CAP | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Person16 | SIXTEEN | CAP | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Person17 | SEVENTEEN | CAP | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Person18 | EIGHTEEN | CAP | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 20 | 21 | 22
Person19 | NINETEEN | UAP | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
[NAME] | TWENTY | UAP | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Person21 | TWENTYONE | UAP | 5 | 7 | 10 | 11 | 12 | 18 | 19 | 22 | 23
Person22 | TWENTYTWO | UAP | 5 | 7 | 10 | 11 | 12 | 18 | 19 | 22 | 23
Person23 | TWENTYTHREE | UAP | 5 | 7 | 10 | 11 | 12 | 18 | 19 | 22 | 23
Person24 | TWENTYFOUR | UAP | 5 | 7 | 10 | 11 | 12 | 18 | 19 | 22 | 23
Person25 | TWENTYFIVE | UAP | 5 | 7 | 10 | 11 | 12 | 18 | 19 | 22 | 23
Person26 | TWENTYSIX | UAP | 19 | 20 | 21 | 22 | 23
Person27 | TWENTYSEVEN | UAP | 19 | 20 | 21 | 22 | 23
Which Server # ?
11
AET list matching
Spreadsheet: cara_semperger__1435__PGE_NOVEMBER_MIDC_PATHS
Sheet: NOV (12)

 |  |  | To Portland General Electric : [NAME], [NAME], and [NAME]
 |  |  | Phone 464-7067
 |  |  | From Enron: Cara, [NAME], and [NAME] |  |  |  |  |  | DAILY COLSTRIP = 0
 |  |  | Phone 464-3814, 3902, 3831 |  |  |  |  |  | MONTH LONG COLSTRIP = 47 ATC
 |  |  |  |  |  |  |  |  | DAILY MIDC = 4 LLH
 |  |  |  |  |  |  |  |  | MIDC PARKING DEAL=50 [NAME]
 |  |  |  |  | Mid Columbia Paths
2001-11-12 00:00:00
 | HLH
 | DAY | 50 | PSEI(G) MIDC-CKFG | X | SCL | ENRON | PGE | X | PARKING
 | DAY | 10 | PSPL(G)MIDC | X | PINWEST | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 12 | GCPD(T)MIDC | X | BP | ENRON | PGE | X | COLSTRIP B/R
 | MONTH | 25 | AVISTA(G)CHELAN | X | AVISTA | ENRON | PGE | X | COLSTRIP B/R
 | LLH
 | DAY | 4 | PGE(G) MIDC | X | PGE | ENRON | AIRPROD | X | LOAD IN PSEI CA AT MIDCO
 | DAY | 2 | BPA C#10440-CLATSKANPE-BPA(T)BPAP/PGE #10649NF | X | CLATSKANPE | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 20 | AVISTA (G) AT CHPD | X | AVISTA | ENRON | PGE | X | COLSTRIP B/R
 | MONTH | 25 | WWP(G)MIDC | X | WWP | ENRON | PGE | X | COLSTRIP B/R
 | MONTH COLSTRIP PATHS
 | ALL HOURS
 | MONTH | 6 |  | X | PGE | ENRON | ASHGROVE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 6 |  | X | PGE | ENRON | EXPRESS PIPE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 7 |  | X | PGE | ENRON | HOLNAM | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 8 |  | X | PGE | ENRON | LOUISIANA P | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 5 |  | X | PGE | ENRON | LUZENAC | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 15 |  | X | PGE | ENRON | SMURFIT | X | MPCO NETWORK TRANSMISSION TO LOAD
Spreadsheet: 129532d1321653579-need-to-search-multiple-vlook-ups-using-if-statement-sample-data-set
Sheet: Sheet2

PlantCode | MarketSegment | ProdHierLevel3Code | NEW PRODUCT |  | Plant | Product | Product Hierarchy | Product | Market Segment | Type
7130 | CC Production Oil | 6B0G00C | ??? |  | 4566 | uknown | 2 | unknown | CC Drilling | DRILLING CHOKE
5378 | CC Production Oil | LA |  |  | 5014 | uknown | 480A00C | uknown | CC Prod Oil Subsea | SUBSEA CHOKE
5161 | CC Drilling | 6B0D00E |  |  | 5145 | uknown | 580E00W | SURFACE CHOKE | CC Production Gas | SURFACE CHOKE
6719 | Not assigned | 680A00C |  |  | 5161 | DYNATORQUE | 680A00C | SURFACE CHOKE | CC Production Oil | SURFACE CHOKE
5145 | CC Production Oil | 6B0P00A |  |  | 5377 | TEST | 680C00W | SURFACE CHOKE
4566 | CC Prod Oil Subsea | 480A00C |  |  | 5378 | TEST | 6B0900P | SURFACE ACTUATOR
4566 | CC Production Gas | 680C00W |  |  | 5390 | TEST | 6B0D00E | DYNATORQUE
6719 | Not assigned | 580E00W |  |  | 6719 | uknown | 6B0G00C | LEDEEN
6719 | Not assigned | 6B0900P |  |  | 7130 | LEDEEN | 6B0H020 | Gate Valve Actuator
5014 | CC Drilling | 2 |  |  |  |  | 6B0P00A | SURFACE ACTUATOR
5014 | CC Production Oil | 6B0H020 |  |  |  |  | LA | unknown
5145 | CC Production Oil | 6807002
Spreadsheet: 805661d1668810067-use-formula-in-cell-if-any-of-three-criteria-are-matched-visual-example
Sheet: Mockup

 |  | The goal is to find information from F column to choose a fomula for G column. There are enough redundancies in column F to find distinct similarities, but in addition to the commonalities, there are also variable numbers and text in the fields. The green column is the best example of this. ie, F17 would be an example of a worst case scenario. Numbers or words may or may not be present, may change, or may even be in a different order, but "Samsung" and "TV" would always be there. |  |  |  |  |  | VLOOKUP? INDEX(MATCH)?
 |  | Car | TV | Year | Actual Description/Data | Results |  | Partial Text V1 | Partial Text V2 | Partial Text V3 | [NAME] to [NAME] to "Results"
 |  | Corvette | None | 1975 | 23 Corvette 92 |  |  | Corvette 92 | Corvette 91 | Corvette 64 | =CONCATENATE([@Car],[@Year])
 |  | Porsche 911 | [NAME] | None | Porsche TV |  |  | Samsung TV | Television | Fighter | =CONCATENATE([@TV],[@Year])
 |  | Corvette | None | 1962 | 963 Corvette 64 |  |  | Porsche TV | Porsche Set | [NAME] | =CONCATENATE([@TV],[@Car])
 |  | None | Samsung | 1993 | Samsung TV 632 1993 |  |  | Known text included in the original data. |  |  | [NAME] that need to be transferred to appropriate "Results" column.
 |  | Porsche [NAME] GT | TV Hybrid | None | The Porsche Set 935
 |  | None | Samsung | 1996 | 964 TV Samsung 243
 |  | Corvette | None | 2030 | 342 Corvette 91
 |  | Magic | [NAME] | Infinity | [NAME] 2030 Car
 |  | None | Sony | 1492 | Television 356
 |  | [NAME] | Hisense | 40K | [NAME] 63
 |  | Information from original sheet. |  |  |  | Final purpose of formula.
Spreadsheet: michael_maggi__26457__NYMEXWEEKLY
Sheet: ng

 |  |  |  |  |  |  |  | 0..
Week Ending: | 2001-11-16 00:00:00
 | Futures Settlement Prices (in  $/MMBtu)
 | HENRY HUB NATURAL GAS |  |  |  |  | Contract Symbol:  NG
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-11-12 00:00:00 | 2001-11-13 00:00:00 | 2001-11-14 00:00:00 | 2001-11-15 00:00:00 | 2001-11-16 00:00:00 | Interest
 | 2001-12-01 00:00:00 | 2.733 | 2.798 | 2.676 | 2.551 | 2.637 | 50854
 | 2002-01-01 00:00:00 | 2.93 | 2.992 | 2.884 | 2.767 | 2.85 | 54171
 | 2002-02-01 00:00:00 | 2.968 | 3.032 | 2.932 | 2.825 | 2.903 | 27837
 | 2002-03-01 00:00:00 | 2.953 | 3.02 | 2.924 | 2.822 | 2.898 | 29452
 | 2002-04-01 00:00:00 | 2.92 | 2.99 | 2.904 | 2.809 | 2.878 | 33177
 | 2002-05-01 00:00:00 | 2.96 | 3.03 | 2.946 | 2.852 | 2.921 | 20833
 | 2002-06-01 00:00:00 | 2.96 | 3.075 | 2.996 | 2.902 | 2.966 | 15430
 | 2002-07-01 00:00:00 | 3.005 | 3.115 | 3.41 | 2.947 | 3.009 | 12871
 | 2002-08-01 00:00:00 | 3.045 | 3.157 | 3.086 | 2.992 | 3.052 | 26563
 | 2002-09-01 00:00:00 | 3.085 | 3.167 | 3.101 | 3.007 | 3.064 | 17495
 | 2002-10-01 00:00:00 | 3.098 | 3.207 | 3.141 | 3.047 | 3.104 | 21357
 | 2002-11-01 00:00:00 | 3.143 | 3.402 | 3.336 | 3.242 | 3.297 | 21819
 | Total Weekly Volume
 |  |  |  |  | Total Open Interest |  | 470987
 |  |  |  | *Weekly volume and open interest reflects all traded months.
 | Historial Volatility-Spot Month Futures
 |  |  |  | [NAME]
 | 5 Day Hist. Vol. |  |  | 0.6971
 | 20 Day Hist. Vol. |  |  | 0.7748
 | Implied Volatility-Options |  |  | [NAME]
 | At the Money Call & Put |  |  | 0.8063
 | MON | TUE | WED | THUR | FRI | Total
Trading Volume | 67677 | 76724 | 85763 | 85886 | 82435
EFS Volume | 2050 | 11200 | 300 | 1400 | 2000