I carried the formula left two columns.

The Launch Year is 2013 for example. Therefore there would be six columns (they are H through M on my sheet) labeled NSV 2010, 2011 and so forth.

If the launch year is 2013, obviously there would be no sales data in 2010-2012; leaving the first three years blank. When I extrapolated that formula out (possibly incorrect) it worked fine if there is a corresponding value in the table but when there is no answer, it still gives an N/A.

Maybe it would help if I attached the spreadsheet?