I'm trying to write a formula to lookup a value in column H, where the date in column B falls between two dates. Essentially I have an amortization table for a loan, and I want to show the interest amount of the payment on a summary tab, where the payment date falls within a certain month. Eg, It's January, show me January's interest amount! But the date of the payment could be any day in the month. I have multiple loans/amortization tables and the payment dates are all different.
Hope this makes sense! I've tried an IF/AND with a VLOOKUP and couldn't get it right.
Bookmarks