Spreadsheet: 207820-using-the-values-in-last-column-to-return-the-values-in-the-first-column-basic-materials
Sheet: Oil & Gas Pipelines

Stock Quotes Provided by MSN Money
Click here to visit MSN Money |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APL
 |  |  | Last | Previous Close | High | Low | Volume | Change | % Change | 52 Wk High | 52 Wk Low | Market [NAME] | EPS | P/E Ratio | # [NAME] Out |  | BKEP
[NAME] | Chart | News | 33.53 | 33.36 | 33.64 | 33.06 | 290992 | 0.17 | 0.0051 | 38.49 | 27.32 | 2139144515 | 1.01 | 33 | 63797930 |  | BPL
Blueknight Energy Partners Units | Chart | News | 7.63 | 7.17 | 7.77 | 7.23 | 61382 | 0.46 | 0.0642 | 7.86 | 6.08 | 277490896 | 0.28 | 25.9 | 36368400 |  | BWP
[NAME] | Chart | News | 53.78 | 53.22 | 54 | 53.04 | 405679 | 0.56 | 0.0105 | 64.36 | 44.37 | 5276313194 | 2.6 | 20.5 | 98109210 |  | CPNO
Boardwalk Pipeline Partners LP | Chart | News | 26.87 | 26.5 | 26.9 | 26.39 | 339024 | 0.37 | 0.014 | 29.16 | 23.55 | 6195518200 | 1.25 | 21.2 | 230573800 |  | CQP
Copano Energy LLC | Chart | News | 33.39 | 33.39 | 33.77 | 33.1 | 313967 | 0 | 0 | 38.03 | 24.24 | 2635784181 | -1.85 |  | 78939330 |  | DPM
Cheniere Energy Partners LP | Chart | News | 24.07 | 24.1 | 24.15 | 24 | 179474 | -0.03 | -0.0012 | 27.47 | 17.59 | 4209176208 | -0.47 |  | 174872300 |  | EEP
DCP Midstream Partners LP | Chart | News | 42.05 | 41.22 | 42.35 | 41.36 | 317477 | 0.83 | 0.0201 | 49.93 | 36.47 | 2568909723 | 1.24 | 33.2 | 61091790 |  | ENB
Enbridge Energy Partners LP | Chart | News | 30.05 | 30.1 | 30.23 | 29.98 | 964993 | -0.05 | -0.0017 | 33.63 | 26.88 | 9091230609 | 1.85 | 16.3 | 302536800 |  | EPB
Enbridge Inc | Chart | News | 44.54 | 44.56 | 44.55 | 44.25 | 464466 | -0.02 | -0.0004 | 44.87 | 35.91 | 35858646981 | 1.04 | 42.5 | 805088600 |  | ETE
El Paso Pipeline Partners LP | Chart | News | 40.82 | 39.89 | 41 | 40.05 | 496152 | 0.93 | 0.0233 | 40.39 | 30.64 | 8808323224 | 2.15 | 18.6 | 215784500 |  | ETP
Energy Transfer Equity LP | Chart | News | 48.91 | 49.02 | 49.11 | 48.55 | 686434 | -0.11 | -0.0022 | 49.34 | 34 | 13692628353 | 1.4 | 25.3 | 279955600 |  | GEL
Energy Transfer Partners LP | Chart | News | 47.25 | 47.3 | 47.5 | 47.01 | 1476760 | -0.05 | -0.0011 | 51 | 40.19 | 14200864650 | 4.53 | 9.2 | 300547400 |  | HEP
Genesis Energy LP | Chart | News | 38.23 | 37.62 | 38.28 | 37.44 | 208773 | 0.61 | 0.0162 | 38.2 | 26.7 | 3102852278 | 1.01 | 37.3 | 81162760 |  | KMI
Holly Energy Partners LP | Chart | News | 35.76 | 36.15 | 36.41 | 35.5 | 65536 | -0.4 | -0.0109 | 36.98 | 26.12 | 2030242258 | 1.45 | 25 | 56782050 |  | KMP
Kinder Morgan Inc | Chart | News | 37.41 | 37.24 | 37.41 | 36.66 | 4698514 | 0.17 | 0.0046 | 40.25 | 30.51 | 38783395762 | 0.32 | 40.8 | 1036712000 |  | KMR
Kinder Morgan Energy Partners LP | Chart | News | 88.65 | 88.13 | 88.8 | 88.15 | 688937 | 0.52 | 0.0059 | 90.6 | 74.15 | 32354644247 | -0.29 | 53.5 | 364970600 |  | MMLP
Kinder Morgan Management LLC | Chart | News | 82.64 | 82.18 | 82.79 | 82.06 | 343020 | 0.46 | 0.0056 | 82.52 | 65.89 | 9380796891 | -0.25 |  | 113514000 |  | MMP
Martin Midstream Partners LP | Chart | News | 33.97 | 33.68 | 33.99 | 33.63 | 70378 | 0.28 | 0.0085 | 37.91 | 29.46 | 887056437 | 3.77 | 33.4 | 26116780 |  | MPLX
Magellan Midstream Partners LP | Chart | News | 48.1 | 47.22 | 48.22 | 47.09 | 357919 | 0.88 | 0.0186 | 48.39 | 32.73 | 10880262945 | 1.73 | 27.3 | 226200900 |  | NGLS
MPLX LP | Chart | News | 32.2 | 32.93 | 33.31 | 31.65 | 191173 | -0.73 | -0.0222 | 34.51 | 25.35 | 2379677622 |  |  | 73903030 |  | NRGM
Targa Resources Partners LP | Chart | News | 39.75 | 39.55 | 39.75 | 39.4 | 622665 | 0.2 | 0.0051 | 45.42 | 32.68 | 3922171853 | 1.82 | 21.7 | 98670990 |  | NS
Inergy Midstream LP | Chart | News | 22.5 | 22.45 | 22.91 | 22.46 | 31488 | 0.05 | 0.0022 | 25.32 | 18.31 | 1690918425 | 0.58 | 38.9 | 75151930 |  | NSH
Nustar Energy LP | Chart | News | 50.69 | 50.44 | 50.8 | 50.36 | 410360 | 0.25 | 0.005 | 62.64 | 38.43 | 3948045288 | -3.12 |  | 77886080 |  | OILT
NuStar GP Holdings LLC | Chart | News | 31.09 | 31.1 | 31.35 | 30.95 | 33005 | -0.01 | -0.0003 | 36.75 | 24.06 | 1324101343 | 0.38 | 82.6 | 42589300 |  | OKS
Oiltanking Partners LP | Chart | News | 39.45 | 39.5 | 40.1 | 39.34 | 7462 | -0.05 | -0.0012 | 41.13 | 27.65 | 1534717633 | 1.79 | 22.1 | 38899800 |  | PAA
Oneok Partners LP | Chart | News | 59.29 | 58.8 | 59.5 | 59 | 226890 | 0.49 | 0.0083 | 61.58 | 50.45 | 13032867125 | 3.64 | 16.1 | 219815600 |  | PBA
Plains All American Pipeline LP | Chart | News | 50.14 | 49.62 | 50.35 | 49.35 | 939607 | 0.52 | 0.0105 | 50.03 | 36.96 | 16748705228 | 2.4 | 20.7 | 334038800 |  | RGP
Pembina Pipeline Corp | Chart | News | 29.36 | 29.55 | 29.47 | 29.24 | 204288 | -0.19 | -0.0064 | 30.93 | 24.15 | 8582121954 | 0.93 | 31.8 | 292306600 |  | SE
Regency Energy Partners LP | Chart | News | 23.63 | 23.48 | 23.83 | 23.4 | 529827 | 0.15 | 0.0064 | 27.4 | 20.58 | 4036114918 | 0.27 | 85.7 | 170804700 |  | SEMG
Spectra Energy Corp | Chart | News | 27.19 | 27.28 | 27.3 | 27.07 | 8694281 | -0.09 | -0.0033 | 32.27 | 26.55 | 17755595116 | 1.55 | 17.7 | 653019300 |  | SEP
SemGroup Corp | Chart | News | 41.84 | 41.69 | 42 | 41.41 | 425907 | 0.15 | 0.0036 | 43 | 26.09 | 1753584698 | 0.03 | 1000.7 | 41911680 |  | SGU
Spectra Energy Partners LP | Chart | News | 34.28 | 34 | 34.7 | 33.88 | 208443 | 0.28 | 0.0082 | 34.02 | 27.15 | 3528138610 | 1.67 | 20.3 | 102921200 |  | SXL
Star Gas Partners LP | Chart | News | 4.4 | 4.4 | 4.42 | 4.36 | 66624 | 0 | 0 | 4.74 | 3.65 | 265401406 | 0.31 | 14.3 | 60318500 |  | TCP
SunoCo Logistics Partners LP | Chart | News | 56.19 | 56.79 | 57.22 | 56.09 | 363936 | -0.6 | -0.0106 | 57.4 | 31.65 | 5819165495 | 3.73 | 15.2 | 103562300 |  | TLLP
TC PipeLines LP | Chart | News | 42.59 | 42.21 | 42.78 | 42 | 246370 | 0.38 | 0.009 | 47.71 | 38.2 | 2277405282 | 2.65 | 15.9 | 53472770 |  | TLP
Tesoro Logistics LP | Chart | News | 43.06 | 42.89 | 43.12 | 42.65 | 221252 | 0.17 | 0.004 | 47.24 | 29.25 | 1905411089 | 1.63 | 26.3 | 44250140 |  | WES
TransMontaigne Partners LP | Chart | News | 40.27 | 40.62 | 40.58 | 39.74 | 39195 | -0.35 | -0.0086 | 41.8 | 29.89 | 582186216 | 2.56 | 15.8 | 14457070 |  | WMB
Western Gas Partners LP | Chart | News | 50.16 | 49.7 | 50.36 | 49.6 | 136757 | 0.46 | 0.0093 | 53.17 | 39.27 | 4812066981 | 1.49 | 33.3 | 95934350
Williams Companies Inc | Chart | News | 34.74 | 33.8 | 34.76 | 33.7 | 8918646 | 0.94 | 0.0278 | 37.56 | 27.25 | 23417043549 | 0.42 | 31.8 | 674065700
Symbol Lookup |  | MSN Money Home |  |  |  | Microsoft Office Tools on the Web
Find stocks, mutual funds, options, indices, and currencies. |  | Discover MSN Money's tools, columns, and more! |  |  |  | Get the latest from Microsoft Office
Terms of Use. © 2013 Microsoft Corporation and/or its suppliers. All rights reserved.
DATA PROVIDERS
Copyright © 2013 Microsoft. All rights reserved.
Quotes are real-time for NASDAQ, NYSE and AMEX. See delay times for other exchanges.
Fundamental company data and historical chart data provided by Thomson Reuters (click for restrictions). Real-time quotes provided by BATS Exchange. Real-time index quotes and delayed quotes supplied by Interactive Data Real-Time Services. Fund summary, fund performance and dividend data provided by Morningstar Inc. Analyst recommendations provided by Zacks Investment Research. StockScouter data provided by Verus Analytics. IPO data provided by Hoover's Inc. Index membership data provided by SIX Telekurs.
Japanese stock price data provided by Nomura Research Institute Ltd.; quotes delayed 20 minutes. Canadian fund data provided by CANNEX Financial Exchanges Ltd.
APL
BKEP
BPL
BWP
CPNO
CQP
DPM
EEP
ENB
EPB
ETE
ETP
GEL
HEP
KMI
KMP
KMR
MMLP
MMP
MPLX
NGLS
NRGM
NS
NSH
OILT
OKS
PAA
PBA
RGP
SE
SEMG
SEP
SGU
SXL
TCP
TLLP
TLP
WES
WMB