=Index(Offset(DateColumn,match(LoanStartDate,DateColumn,0),0),match(0,Offset(PrincipleColumn,match(LoanStartDate,DateColumn,0),0),-1)) In comes OFFSET like a hero, to save the day. Well, if the loan hasn't started by the time we are in that structure, and I'm trying to see when it will payoff based off early repayment plans, I can't simply match off 0, because the data starts 0 filled since there wasn't a principle yet. Each column after A then, is each loans principle (Even columns), and interest (odd columns). With Column A containing a date, starting at the earliest loan start date, and going down 1 month at a time per row. Then on say, row 20 starts the amortization schedule. I have an amortization schedule for multiple loans with their stats in the first few rows (APR, Term, Start Date). Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown.Īnd if Index Match can't do it, INDIRECT and/or OFFSET, can probably get you there.
Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified
0 kommentar(er)
