Trying to setup a speadsheet that auto updates values that i've designated by date

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

What are you trying to achieve with the "1+8" at the end of the formula in K17?

The bill date is the 9th of each month. I suppose I could've just said 9. The 1 was already a part of the original function and I was just testing what would work.

Try the following formula

K17 = DATE(YEAR(TODAY()), MONTH(TODAY()), Day(9))

K17 = DATE(YEAR(TODAY()), MONTH(TODAY()), Day(9)) Produces a value of Month/8/Year... oddly enough.

But K17 = DATE(YEAR(TODAY()), MONTH(TODAY()), 9) works.

It still produces a blank value in conjunction with VLOOKUP though.

Originally Posted by JeteMc

For K19 try:

Formula:

=INDEX(J2:J75,MATCH(DATE(YEAR(TODAY()),MONTH(TODAY()),9),D2:D75,0))

OR

Formula:

=INDEX(J2:J75,MATCH(K17,D2:D75,0))

Let us know if you have any questions.

My issue was that I was referencing information from column 6 which was blank instead of column 7 that contained the final loan amount. Silly mistake from an amatuer user. Thank you for your response though.