Enter a nested function in cell F$9$ using INDEX and MATCH to find the ending balance for the date listed in cell C$8.$ Use the named range Schedule to reference the cell range for the schedule of loan payments. The Ending Balance column is column $6.$ In the INDEX Row$\_$ num function argument, use MATCH to look up the row number for the date listed in C$8.$ Use the named range Paypates to reference the cell range for the Payment Date column. Require an exact match.