#N/A Error - Index Match Formula - What am I missing?!

[jamestgarner]

[FONT=&quot]I am using an Index Match formula that appears fairly simple, but continues to return #N/A when I see the lookup value in the array. Perhaps I am missing something minute.[/FONT]
[FONT=&quot]I would like to return the date in column T with the matching number in column S. The specific value that I'm trying to match is in cell T5, which happens to be the value "341". Here is an example of the table in excel I am trying to index/match.[/FONT]
[TABLE="width: 794"]
<tbody style="box-sizing: border-box; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased;">[TR]
[TD="align: center"]Cell Reference[/TD]
[TD="align: center"]S[/TD]
[TD="align: center"]T[/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1/1/2010[/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2/1/2010[/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]3/1/2010[/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]4/1/2010[/TD]
[/TR]
[TR]
[TD="align: center"]18[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5/1/2010[/TD]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]6/1/2010[/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]7/1/2010[/TD]
[/TR]
[TR]
[TD="align: center"]...[/TD]
[TD="align: center"]...[/TD]
[TD="align: center"]...[/TD]
[/TR]
[TR]
[TD="align: center"]533[/TD]
[TD="align: center"]520[/TD]
[TD="align: center"]4/1/2053[/TD]
[/TR]
</tbody>[/TABLE]
[FONT=&quot]And my formula is as follows:[/FONT]
[FONT=&quot]=INDEX(T14:T533,MATCH(T5,S14:S533,0))[/FONT]
[FONT=&quot]Where T5 is the Value "341" that I am trying to match from the numbered list in column S (S14:S533) and return the corresponding date in Column T (T14:T533).[/FONT]
[FONT=&quot]Why is this not working? What am I missing here?[/FONT]

 

[63falcondude]

Works fine for me. I got 5/1/2038.

 

[Domenic]

Maybe the number in T5 is being recognized as a text value instead of a numerical value. Or, maybe the numbers in S14:S533 are being recognized as text values. In either case, there would be a mismatch of data types, hence the #N/A error value. The ISNUMBER function can be used to test for numerical values. So, for example, to test whether T5 contains a numerical value...

=ISNUMBER(T5)

Is it the case that there's a mismatch of data types?

 

[63falcondude]

Also, make sure there are no spaces such as "341 " or " 341".

 

[jamestgarner]

It's very strange because I made sure they are all formatted as numbers and still the error. I tried vlookup instead, and received the error. The number 341 is actually pulling from a formula which subtracts two dates and divides by 7 to get a "Number of Weeks". I tried having the index/match pull from cell T4 where T4=T5 to try and eliminate an issue with the formula/formatting that way, but still got the error. Any other ideas?

 

[63falcondude]

I bet that it isn't 341 but instead something like 340.98 or 341.4

You can try adding a rounding function into your formula to ensure that it gives you the correct lookup value.