Need a formula that will pull information from a given source

[pinas]

I am wanting to enter a date on sheet 2 and pull the "principal" from the Loan Calculator sheet into the principal on sheet 2 and the same for "interest" please see attachment I need the sheet to update as I change the date

[Ace_XL]

Principal
=INDEX('Loan Calculator'!$F$16:$F$375,MATCH(F4,'Loan Calculator'!$C$16:$C$375,0))

Interest
=INDEX('Loan Calculator'!$G$16:$G$375,MATCH(F4,'Loan Calculator'!$C$16:$C$375,0))

[etaf]

you can use a lookup or a index match
just not sure what date to lookup

am I looking down column C in Loan Calculator
for the date and then returning F

if so
=INDEX('Loan Calculator'!F16:F159,MATCH(Sheet2!F4,'Loan Calculator'!C16:C159,0))

see attached

[elliotencore]

Loan calculator and amortization table joel.xlsx

VLOOKUP and MATCH combination

[pinas]

Thank you so much works perfect