Excel 2007 INDEX and MATCH returning #N/A

jm6239

New Member
Joined
Jul 12, 2007
Messages
27
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.
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,132,679
Messages
5,654,714
Members
418,149
Latest member
tjanok

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top