Spreadsheet: 675066d1588143151-unable-to-use-index-and-match-function-to-fetch-values-task2profitandlossstatementcopy
Sheet: TickerandYears

Ticker Symbol |  | Ticker Symbol |  | Row Labels |  | Years_List
AAL |  | AAL |  | 2003 |  | 2003
AAL |  | AAP |  | 2004 |  | 2004
AAL |  | AAPL |  | 2006 |  | 2006
AAL |  | ABBV |  | 2007 |  | 2007
AAP |  | ABC |  | 2012 |  | 2012
AAP |  | ABT |  | 2013 |  | 2013
AAP |  | ADBE |  | 2014 |  | 2014
AAP |  | ADI |  | 2015 |  | 2015
AAPL |  | ADM |  | 2016 |  | 2016
AAPL |  | ADS |  | 2017 |  | 2017
AAPL |  | ADSK
AAPL |  | AEE
ABBV |  | AEP
ABBV |  | AFL
ABBV |  | AIG
ABBV |  | AIV
ABC |  | AIZ
ABC |  | AKAM
ABC |  | ALB
ABC |  | ALK
ABT |  | ALL
ABT |  | ALLE
ABT |  | ALXN
ABT |  | AMAT
ADBE |  | AME
ADBE |  | AMGN
ADBE |  | AMP
ADBE |  | AMT
ADI |  | AMZN
ADI |  | AN
ADI |  | ANTM
ADI |  | APA
ADM |  | APC
ADM |  | APD
ADM |  | APH
ADM |  | ARNC
ADS |  | ATVI
ADS |  | AVGO
ADS |  | AVY
ADS |  | AWK
ADSK |  | AXP
ADSK |  | AYI
ADSK |  | AZO
ADSK |  | BA
AEE |  | BAC
AEE |  | BAX
AEE |  | BBBY
AEE |  | BBT
AEP |  | BBY
AEP |  | BCR
AEP |  | BDX
AEP |  | BHI
AFL |  | BIIB
AFL |  | BLL
AFL |  | BMY
AFL |  | BSX
AIG |  | BWA
AIG |  | BXP
AIG |  | CAG
AIG |  | CAH
AIV |  | CAT
AIV |  | CB
AIV |  | CBG
AIV |  | CCI
AIZ |  | CCL
AIZ |  | CELG
AIZ |  | CERN
AIZ |  | CF
AKAM |  | CFG
AKAM |  | CHD
AKAM |  | CHK
AKAM |  | CHRW
ALB |  | CHTR
ALB |  | CI
ALB |  | CINF
ALB |  | CL
ALK |  | CLX
ALK |  | CMA
ALK |  | CMG
ALK |  | CMI
ALL |  | CMS
ALL |  | CNC
ALL |  | CNP
ALL |  | COF
ALLE |  | COG
ALLE |  | COL
ALLE |  | COO
ALLE |  | COST
ALXN |  | COTY
ALXN |  | CPB
ALXN |  | CRM
ALXN |  | CSCO
AMAT |  | CSRA
AMAT |  | CSX
AMAT |  | CTAS
AMAT |  | CTL
AME |  | CTSH
AME |  | CTXS
AME |  | CVS
AME |  | CVX
AMGN |  | CXO
AMGN |  | D
AMGN |  | DAL
AMGN |  | DD
AMP |  | DE
AMP |  | DFS
AMP |  | DG
AMP |  | DGX
AMT |  | DHI
AMT |  | DHR
AMT |  | DIS
AMT |  | DISCA
AMZN |  | DISCK
AMZN |  | DLPH
AMZN |  | DLR
AMZN |  | DLTR
AN |  | DNB
AN |  | DOV
AN |  | DPS
AN |  | DRI
ANTM |  | [NAME]
ANTM |  | DVA
ANTM |  | DVN
ANTM |  | EA
APA |  | EBAY
APA |  | ECL
APA |  | ED
APA |  | EFX
APC |  | EIX
APC |  | EL
APC |  | EMN
APC |  | EMR
APD |  | EOG
APD |  | EQIX
APD |  | EQR
APD |  | EQT
APH |  | ES
APH |  | ESS
APH |  | ETFC
APH |  | ETN
ARNC |  | ETR
ARNC |  | EW
ARNC |  | EXC
ARNC |  | EXPD
ATVI |  | EXPE
ATVI |  | EXR
ATVI |  | F
ATVI |  | FAST
AVGO |  | FB
AVGO |  | FBHS
AVY |  | FCX
AVY |  | FDX
AVY |  | FE
AVY |  | FFIV
AWK |  | FIS
AWK |  | FISV
AWK |  | FL
AWK |  | FLIR
AXP |  | FLR
AXP |  | FLS
AXP |  | FMC
AXP |  | FRT
AYI |  | FSLR
AYI |  | FTR
AYI |  | [NAME]
AYI |  | GGP
AZO |  | GILD
AZO |  | GIS
AZO |  | GLW
AZO |  | GM
BA |  | GPC
BA |  | GPN
BA |  | GPS
BA |  | [NAME]
BAC |  | GT
BAC |  | GWW
BAC |  | HAL
BAC |  | HAR
BAX |  | HAS
BAX |  | HBAN
BAX |  | HBI
BAX |  | HCA
BBBY |  | HCN
BBBY |  | HCP
BBBY |  | HD
BBBY |  | HES
BBT |  | HIG
BBT |  | HOG
BBT |  | HOLX
BBT |  | HON
BBY |  | HP
BBY |  | HPE
BBY |  | HPQ
BBY |  | HRB
BCR |  | HRL
BCR |  | HRS
BCR |  | HSIC
BCR |  | HST
BDX |  | HSY
BDX |  | HUM
BDX |  | IBM
BDX |  | IDXX
BHI |  | IFF
BHI |  | ILMN
BHI |  | INTC
BHI |  | INTU
BIIB |  | IP
BIIB |  | IPG
BIIB |  | IRM
BIIB |  | ISRG
BLL |  | ITW
BLL |  | IVZ
BLL |  | JBHT
BLL |  | JEC
BMY |  | JNPR
BMY |  | JPM
BMY |  | JWN
BMY |  | K
BSX |  | KEY
BSX |  | [NAME]
BSX |  | KLAC
BSX |  | KMB
BWA |  | KMI
BWA |  | KMX
BWA |  | KO
BWA |  | [NAME]
BXP |  | KR
BXP |  | KSS
BXP |  | KSU
BXP |  | LB
CAG |  | LEG
CAG |  | LEN
CAG |  | LH
CAG |  | LKQ
CAH |  | LLL
CAH |  | LLTC
CAH |  | LLY
CAH |  | LMT
CAT |  | LNT
CAT |  | LOW
CAT |  | LRCX
CAT |  | LUK
CB |  | LUV
CB |  | LVLT
CB |  | LYB
CB |  | M
CBG |  | MA
CBG |  | MAA
CBG |  | MAC
CBG |  | MAR
CCI |  | MAS
CCI |  | MAT
CCI |  | MCD
CCI |  | MCHP
CCL |  | MCK
CCL |  | MCO
CCL |  | MDLZ
CCL |  | MET
CELG |  | MHK
CELG |  | MJN
CELG |  | MKC
CELG |  | MLM
CERN |  | MMC
CERN |  | MMM
CERN |  | MNST
CERN |  | MO
CF |  | MON
CF |  | MOS
CF |  | MPC
CF |  | MRK
CFG |  | MRO
CFG |  | MSFT
CFG |  | MTB
CFG |  | MTD
CHD |  | MU
CHD |  | MUR
CHD |  | MYL
CHD |  | NBL
CHK |  | NDAQ
CHK |  | NEE
CHK |  | NEM
CHK |  | NFLX
CHRW |  | NFX
CHRW |  | NKE
CHRW |  | NLSN
CHRW |  | NOV
CHTR |  | NSC
CHTR |  | NTAP
CHTR |  | NUE
CHTR |  | NVDA
CI |  | NWL
CI |  | O
CI |  | OKE
CI |  | OMC
CINF |  | ORLY
CINF |  | OXY
CINF |  | PBCT
CINF |  | PBI
CL |  | PCAR
CL |  | PCG
CL |  | PCLN
CL |  | PDCO
CLX |  | PEG
CLX |  | PEP
CLX |  | PFE
CLX |  | PFG
CMA |  | PG
CMA |  | PGR
CMA |  | PH
CMA |  | PHM
CMG |  | PKI
CMG |  | PM
CMG |  | PNC
CMG |  | PNR
CMI |  | PNW
CMI |  | PPG
CMI |  | PPL
CMI |  | PRU
CMS |  | PSX
CMS |  | PVH
CMS |  | PWR
CMS |  | PX
CNC |  | QCOM
CNC |  | QRVO
CNC |  | R
CNC |  | RCL
CNP |  | REGN
CNP |  | RHI
CNP |  | RHT
CNP |  | RL
COF |  | ROK
COF |  | ROP
COF |  | ROST
COF |  | RRC
COG |  | RSG
COG |  | SBUX
COG |  | SCG
COG |  | SE
COL |  | SEE
COL |  | SHW
COL |  | SIG
COL |  | SJM
COO |  | SLG
COO |  | SNA
COO |  | SNI
COO |  | SO
COST |  | SPG
COST |  | SPLS
COST |  | SRCL
COST |  | SRE
COTY |  | STI
COTY |  | STX
COTY |  | STZ
COTY |  | SWK
CPB |  | SWKS
CPB |  | SWN
CPB |  | SYF
CPB |  | SYK
CRM |  | SYMC
CRM |  | SYY
CRM |  | T
CRM |  | TAP
CSCO |  | TDC
CSCO |  | TDG
CSCO |  | TEL
CSCO |  | TGNA
CSRA |  | TGT
CSRA |  | TIF
CSX |  | TJX
CSX |  | TMK
CSX |  | TMO
CSX |  | TRIP
CTAS |  | TRV
CTAS |  | TSCO
CTAS |  | TSN
CTAS |  | TSO
CTL |  | TSS
CTL |  | TXN
CTL |  | TXT
CTL |  | UA
CTSH |  | UAA
CTSH |  | UAL
CTSH |  | UDR
CTSH |  | ULTA
CTXS |  | UNH
CTXS |  | UNM
CTXS |  | UNP
CTXS |  | UPS
CVS |  | URBN
CVS |  | USB
CVS |  | UTX
CVS |  | V
CVX |  | VAR
CVX |  | VFC
CVX |  | VIAB
CVX |  | VLO
CXO |  | VMC
CXO |  | VNO
CXO |  | VRSK
CXO |  | VRSN
D |  | VRTX
D |  | VTR
D |  | VZ
D |  | WAT
DAL |  | WDC
DAL |  | WEC
DAL |  | WFC
DAL |  | WFM
DD |  | WHR
DD |  | WM
DD |  | WMB
DD |  | WMT
DE |  | WRK
DE |  | WU
DE |  | WY
DE |  | WYN
DFS |  | WYNN
DFS |  | XEC
DFS |  | XEL
DFS |  | XL
DG |  | XLNX
DG |  | XOM
DG |  | XRAY
DG |  | [NAME]
DGX |  | XYL
DGX |  | YHOO
DGX |  | YUM
DGX |  | ZBH
DHI |  | ZION
DHI |  | ZTS
DHI
DHI
DHR
DHR
DHR
DHR
DIS
DIS
DIS
DIS
DISCA
DISCA
DISCA
DISCA
DISCK
DISCK
DISCK
DISCK
DLPH
DLPH
DLPH
DLPH
DLR
DLR
DLR
DLR
DLTR
DLTR
DLTR
DLTR
DNB
DNB
DNB
DNB
DOV
DOV
DOV
DOV
DPS
DPS
DPS
DPS
DRI
DRI
DRI
DRI
[NAME]
[NAME]
[NAME]
[NAME]
DVA
DVA
DVA
DVA
DVN
DVN
DVN
DVN
EA
EA
EA
EA
EBAY
EBAY
EBAY
EBAY
ECL
ECL
ECL
ECL
ED
ED
ED
ED
EFX
EFX
EFX
EFX
EIX
EIX
EIX
EIX
EL
EL
EL
EL
EMN
EMN
EMN
EMN
EMR
EMR
EMR
EMR
EOG
EOG
EOG
EOG
EQIX
EQIX
EQIX
EQIX
EQR
EQR
EQR
EQR
EQT
EQT
EQT
EQT
ES
ES
ES
ES
ESS
ESS
ESS
ESS
ETFC
ETFC
ETFC
ETFC
ETN
ETN
ETN
ETN
ETR
ETR
ETR
ETR
EW
EW
EW
EW
EXC
EXC
EXC
EXC
EXPD
EXPD
EXPD
EXPD
EXPE
EXPE
EXPE
EXPE
EXR
EXR
EXR
EXR
F
F
F
F
FAST
FAST
FAST
FAST
FB
FB
FB
FB
FBHS
FBHS
FBHS
FBHS
FCX
FCX
FCX
FCX
FDX
FDX
FDX
FDX
FE
FE
FE
FE
FFIV
FFIV
FFIV
FFIV
FIS
FIS
FIS
FIS
FISV
FISV
FISV
FISV
FL
FL
FL
FL
FLIR
FLIR
FLIR
FLIR
FLR
FLR
FLR
FLR
FLS
FLS
FLS
FLS
FMC
FMC
FMC
FMC
FRT
FRT
FRT
FRT
FSLR
FSLR
FSLR
FSLR
FTR
FTR
FTR
FTR
[NAME]
[NAME]
[NAME]
[NAME]
GGP
GGP
GGP
GGP
GILD
GILD
GILD
GILD
GIS
GIS
GIS
GIS
GLW
GLW
GLW
GLW
GM
GM
GM
GM
GPC
GPC
GPC
GPC
GPN
GPN
GPN
GPN
GPS
GPS
GPS
GPS
[NAME]
[NAME]
[NAME]
[NAME]
GT
GT
GT
GT
GWW
GWW
GWW
GWW
HAL
HAL
HAL
HAL
HAR
HAR
HAR
HAR
HAS
HAS
HAS
HAS
HBAN
HBAN
HBAN
HBAN
HBI
HBI
HBI
HBI
HCA
HCA
HCA
HCA
HCN
HCN
HCN
HCN
HCP
HCP
HCP
HCP
HD
HD
HD
HD
HES
HES
HES
HES
HIG
HIG
HIG
HIG
HOG
HOG
HOG
HOG
HOLX
HOLX
HOLX
HOLX
HON
HON
HON
HON
HP
HP
HP
HP
HPE
HPE
HPE
HPQ
HPQ
HPQ
HPQ
HRB
HRB
HRB
HRB
HRL
HRL
HRL
HRL
HRS
HRS
HRS
HRS
HSIC
HSIC
HSIC
HSIC
HST
HST
HST
HST
HSY
HSY
HSY
HSY
HUM
HUM
HUM
HUM
IBM
IBM
IBM
IBM
IDXX
IDXX
IDXX
IDXX
IFF
IFF
IFF
IFF
ILMN
ILMN
ILMN
ILMN
INTC
INTC
INTC
INTC
INTU
INTU
INTU
INTU
IP
IP
IP
IP
IPG
IPG
IPG
IPG
IRM
IRM
IRM
IRM
ISRG
ISRG
ISRG
ISRG
ITW
ITW
ITW
ITW
IVZ
IVZ
IVZ
IVZ
JBHT
JBHT
JBHT
JBHT
JEC
JEC
JEC
JEC
JNPR
JNPR
JNPR
JNPR
JPM
JPM
JPM
JPM
JWN
JWN
JWN
JWN
K
K
K
K
KEY
KEY
KEY
KEY
[NAME]
[NAME]
[NAME]
[NAME]
KLAC
KLAC
KLAC
KLAC
KMB
KMB
KMB
KMB
KMI
KMI
KMI
KMI
KMX
KMX
KMX
KMX
KO
KO
KO
KO
[NAME]
[NAME]
[NAME]
[NAME]
KR
KR
KR
KR
KSS
KSS
KSS
KSS
KSU
KSU
KSU
KSU
LB
LB
LB
LB
LEG
LEG
LEG
LEG
LEN
LEN
LEN
LEN
LH
LH
LH
LH
LKQ
LKQ
LKQ
LKQ
LLL
LLL
LLL
LLL
LLTC
LLTC
LLTC
LLTC
LLY
LLY
LLY
LLY
LMT
LMT
LMT
LMT
LNT
LNT
LNT
LNT
LOW
LOW
LOW
LOW
LRCX
LRCX
LRCX
LRCX
LUK
LUK
LUK
LUK
LUV
LUV
LUV
LUV
LVLT
LVLT
LVLT
LVLT
LYB
LYB
LYB
LYB
M
M
M
M
MA
MA
MA
MA
MAA
MAA
MAA
MAA
MAC
MAC
MAC
MAC
MAR
MAR
MAR
MAR
MAS
MAS
MAS
MAS
MAT
MAT
MAT
MAT
MCD
MCD
MCD
MCD
MCHP
MCHP
MCHP
MCHP
MCK
MCK
MCK
MCK
MCO
MCO
MCO
MCO
MDLZ
MDLZ
MDLZ
MDLZ
MET
MET
MET
MET
MHK
MHK
MHK
MHK
MJN
MJN
MJN
MJN
MKC
MKC
MKC
MKC
MLM
MLM
MLM
MLM
MMC
MMC
MMC
MMC
MMM
MMM
MMM
MMM
MNST
MNST
MNST
MNST
MO
MO
MO
MO
MON
MON
MON
MON
MOS
MOS
MOS
MOS
MPC
MPC
MPC
MPC
MRK
MRK
MRK
MRK
MRO
MRO
MRO
MRO
MSFT
MSFT
MSFT
MSFT
MTB
MTB
MTB
MTB
MTD
MTD
MTD
MTD
MU
MU
MU
MU
MUR
MUR
MUR
MUR
MYL
MYL
NBL
NBL
NBL
NBL
NDAQ
NDAQ
NDAQ
NDAQ
NEE
NEE
NEE
NEE
NEM
NEM
NEM
NEM
NFLX
NFLX
NFLX
NFLX
NFX
NFX
NFX
NFX
NKE
NKE
NKE
NKE
NLSN
NLSN
NLSN
NLSN
NOV
NOV
NOV
NOV
NSC
NSC
NSC
NSC
NTAP
NTAP
NTAP
NTAP
NUE
NUE
NUE
NUE
NVDA
NVDA
NVDA
NVDA
NWL
NWL
NWL
NWL
O
O
O
O
OKE
OKE
OKE
OKE
OMC
OMC
OMC
ORLY
ORLY
ORLY
ORLY
OXY
OXY
OXY
OXY
PBCT
PBCT
PBCT
PBCT
PBI
PBI
PBI
PBI
PCAR
PCAR
PCAR
PCAR
PCG
PCG
PCG
PCG
PCLN
PCLN
PCLN
PCLN
PDCO
PDCO
PDCO
PDCO
PEG
PEG
PEG
PEG
PEP
PEP
PEP
PEP
PFE
PFE
PFE
PFE
PFG
PFG
PFG
PFG
PG
PG
PG
PG
PGR
PGR
PGR
PGR
PH
PH
PH
PH
PHM
PHM
PHM
PHM
PKI
PKI
PKI
PKI
PM
PM
PM
PM
PNC
PNC
PNC
PNC
PNR
PNR
PNR
PNR
PNW
PNW
PNW
PNW
PPG
PPG
PPG
PPG
PPL
PPL
PPL
PPL
PRU
PRU
PRU
PRU
PSX
PSX
PSX
PSX
PVH
PVH
PVH
PVH
PWR
PWR
PWR
PWR
PX
PX
PX
PX
QCOM
QCOM
QCOM
QCOM
QRVO
QRVO
QRVO
R
R
R
R
RCL
RCL
RCL
RCL
REGN
REGN
REGN
REGN
RHI
RHI
RHI
RHI
RHT
RHT
RHT
RHT
RL
RL
RL
RL
ROK
ROK
ROK
ROK
ROP
ROP
ROP
ROP
ROST
ROST
ROST
ROST
RRC
RRC
RRC
RRC
RSG
RSG
RSG
RSG
SBUX
SBUX
SBUX
SBUX
SCG
SCG
SCG
SCG
SE
SE
SE
SE
SEE
SEE
SEE
SEE
SHW
SHW
SHW
SHW
SIG
SIG
SIG
SIG
SJM
SJM
SJM
SJM
SLG
SLG
SLG
SLG
SNA
SNA
SNA
SNA
SNI
SNI
SNI
SNI
SO
SO
SO
SO
SPG
SPG
SPG
SPG
SPLS
SPLS
SPLS
SPLS
SRCL
SRCL
SRCL
SRCL
SRE
SRE
SRE
SRE
STI
STI
STI
STI
STX
STX
STX
STX
STZ
STZ
STZ
STZ
SWK
SWK
SWK
SWK
SWKS
SWKS
SWKS
SWKS
SWN
SWN
SWN
SWN
SYF
SYF
SYF
SYF
SYK
SYK
SYK
SYK
SYMC
SYMC
SYMC
SYMC
SYY
SYY
SYY
SYY
T
T
T
T
TAP
TAP
TAP
TAP
TDC
TDC
TDC
TDC
TDG
TDG
TDG
TDG
TEL
TEL
TEL
TEL
TGNA
TGNA
TGNA
TGNA
TGT
TGT
TGT
TGT
TIF
TIF
TIF
TIF
TJX
TJX
TJX
TJX
TMK
TMK
TMK
TMK
TMO
TMO
TMO
TMO
TRIP
TRIP
TRIP
TRIP
TRV
TRV
TRV
TRV
TSCO
TSCO
TSCO
TSCO
TSN
TSN
TSN
TSN
TSO
TSO
TSO
TSO
TSS
TSS
TSS
TSS
TXN
TXN
TXN
TXN
TXT
TXT
TXT
TXT
UA
UA
UA
UA
UAA
UAA
UAA
UAA
UAL
UAL
UAL
UAL
UDR
UDR
UDR
UDR
ULTA
ULTA
ULTA
ULTA
UNH
UNH
UNH
UNH
UNM
UNM
UNM
UNM
UNP
UNP
UNP
UNP
UPS
UPS
UPS
UPS
URBN
URBN
URBN
URBN
USB
USB
USB
USB
UTX
UTX
UTX
UTX
V
V
V
V
VAR
VAR
VAR
VAR
VFC
VFC
VFC
VFC
VIAB
VIAB
VIAB
VIAB
VLO
VLO
VLO
VLO
VMC
VMC
VMC
VMC
VNO
VNO
VNO
VNO
VRSK
VRSK
VRSK
VRSK
VRSN
VRSN
VRSN
VRSN
VRTX
VRTX
VRTX
VRTX
VTR
VTR
VTR
VTR
VZ
VZ
VZ
VZ
WAT
WAT
WAT
WAT
WDC
WDC
WDC
WDC
WEC
WEC
WEC
WEC
WFC
WFC
WFC
WFC
WFM
WFM
WFM
WFM
WHR
WHR
WHR
WHR
WM
WM
WM
WM
WMB
WMB
WMB
WMB
WMT
WMT
WMT
WMT
WRK
WRK
WRK
WU
WU
WU
WU
WY
WY
WY
WY
WYN
WYN
WYN
WYN
WYNN
WYNN
WYNN
WYNN
XEC
XEC
XEC
XEC
XEL
XEL
XEL
XEL
XL
XL
XL
XL
XLNX
XLNX
XLNX
XLNX
XOM
XOM
XOM
XOM
XRAY
XRAY
XRAY
XRAY
[NAME]
[NAME]
[NAME]
[NAME]
XYL
XYL
XYL
XYL
YHOO
YHOO
YHOO
YHOO
YUM
YUM
YUM
YUM
ZBH
ZBH
ZBH
ZBH
ZION
ZION
ZION
ZION
ZTS
ZTS
ZTS
ZTS