I'm trying to setup my Loan spreadsheet to update the current value remaining into a single cell but I don't have a strong understanding of excel. Can someone please assist me in fixing my function it keeps returning a blank value.. I would like it to read something akin to:

K19 =VLOOKUP(K17, D1:J74, 6).

K17 =DATE(YEAR(TODAY()), MONTH(TODAY()), 1+8).

excellscreenshot.PNG