=index(Match return N/A.

[bloodybrit90]

Hi Guys,

The formula I am using returns #N/A. The formula is

=INDEX(Amort!J12:J751,MATCH(D4&12,Amort!D12:D751&Amort!C12:C751,0))

Info:
I have a monthly amort schedule in sheet 1 and need to return the end balance to sheet 2 if it matches the year in sheet 2.

Sheet 1 looks like this.

C D J
11 Month Year End Balance
12 01 2011 $600,849

On sheet 2 rows D4 to L4 have the different years.

D E F .......
4 2012 2013 2014 .......

I thought my formula should return the end balance in Colum J if sheet 2 D4&12 (year and 12th month) match the year in column D and Month column C.

=INDEX(Sheet1!J12:J751,MATCH(D4&12,Sheet1!D12:D751&Sheet1!C12:C751,0))

 

[vlady]

ctrl + shift + enter ????
instead of enter only

 

[bloodybrit90]

Yea that worked. Thanks for the help.