Name error when file opened in Excel 2010 and not 2013

[csenor]

I have a workbook that I created in Excel 2013 for a vehicle fleet service history. I have formulas that look up the last mileage in a year and subtracts that from the first mileage of that year. The formulas are looking at an Excel table on another sheet. There are no named ranges. The formulas worked fine until I tried to open it in 2010 and add a record to the data table. The second I add a record, I get Name errors. Any ideas? I reopen it in 2013 and add a record and it works fine. I didn't think there were any compatibility issues with using the functions I used, but I could be wrong.

Formula:
=IFNA(LOOKUP(DATE($D2+1,1,1),1/(YEAR(DataTable!$B$9:$B$66)=D2)*1/(DataTable!$A$9:$A$66=$B$1),DataTable!$D$9:$D$66)-MIN(IF(DataTable!$A$9:$A$66=$B$1,IF(YEAR(DataTable!$B$9:$B$66)=$D2,DataTable!$D$9:$D$66))),"")

Any input would be appreciated. Thanks.

 

[Weazel]

IFNA is not an available function in excel 2010, you'd probably want to replace it with IFERROR

 

[csenor]

Thanks. That was the problem.