Have the below results from an ODBC oracle query. Count is in column Y, Dates is in Column Z and the third column is in column AA
all active projects
COUNT(*) TO_CHAR(TRUNC(PJ.CREATEDON,'YE DECODE(NVL(PJ.ASSETOWNERID,1),
6 2001 Wireline
117 2004 Mobility
114 2005 Mobility
113 2006 Mobility
71 2007 Mobility
1 2007 Wireline
2654 2008 Wireline
4170 2008 Mobility
3293 2009 Wireline
428 2009 Mobility
5712 2010 Wireline
632 2010 Mobility
Wireline --> Z17
2005 --> Z18
#N/A
Formula using is:
=INDEX(Y2:Y14,MATCH(Z17&Z18,AA2:AA14&Z2:Z14,0))
used CTRL+SHIFT+ENTER on the formula.
I have tried every format of the years the query returns, and tried multiple different lookup functions with luck.
Any help would be greatly appreciated.
all active projects
COUNT(*) TO_CHAR(TRUNC(PJ.CREATEDON,'YE DECODE(NVL(PJ.ASSETOWNERID,1),
6 2001 Wireline
117 2004 Mobility
114 2005 Mobility
113 2006 Mobility
71 2007 Mobility
1 2007 Wireline
2654 2008 Wireline
4170 2008 Mobility
3293 2009 Wireline
428 2009 Mobility
5712 2010 Wireline
632 2010 Mobility
Wireline --> Z17
2005 --> Z18
#N/A
Formula using is:
=INDEX(Y2:Y14,MATCH(Z17&Z18,AA2:AA14&Z2:Z14,0))
used CTRL+SHIFT+ENTER on the formula.
I have tried every format of the years the query returns, and tried multiple different lookup functions with luck.
Any help would be greatly appreciated.
