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.
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,495
Messages
5,511,662
Members
408,859
Latest member
willm57

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top