On the June2017 worksheet, in cell E4, use the INDEX function to identify the transaction amount that aligns with the position in cell C4. Type 5 for the column_num and use the range A7:E24 as the array argument.

AutoSave Off H5 exploring_ecap-grader_c2_Transactions_WilcoxMichaela wilcoxmckay@gmail.com W File Home Insert Formulas Data Review View Help JMP Share Comments Draw Page Layout Lo Recent Sources C Existing Connections Queries & Connections 1 L From Text/CSV Le From Web From Table/Range DA Clear Te Reapply A1 A2 Z 8 Sort Properties Refresh All Edit Links Stocks Filter Get Data Outline Geography Text to Columns What If Forecast Analysis v Sheet Lo Advanced Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast F9 : fi K L M E Amount 6 7 -800 8 9 Groceries Total Cost: $ 652.33 Average Cost: $ 36.24 Occurrences: 2 Groceries - Credit Card Total Cost: $ (109.64) Average Cost: $ (109.64) Occurrences: 1 10 11 12 13 14 15 16 17 A B Date Payee 6/1/2017 Zachary Kaye 6/4/2017 Visa 6/8/2017 South & Main 6/8/2017 Income 6/8/2017 [Savings Account] 6/15/2017 SEC 6/15/2017 Springfield Savings & Loans 6/18/2017 Gas-N-Wash 6/18/2017 SGW 6/22/2017 South & Main 6/22/2017 Income 6/22/2017 [Savings Account] 6/23/2017 George's SuperMart 6/25/2017 CIV Solutions 6/25/2017 Springfield Savings & Loans 6/28/2017 AMP Insurance 6/29/2017 Sam's Stop 6/30/2017 George's SuperMart Category Rent Credit Card Payment ATM Withdrawal Salary Transfer to Savings Electric Bill Student Loan Gas Water Bill ATM Withdrawal Salary Transfer to Savings Groceries Cable/Internet Car Loan Car Insurance Gas Groceries D Method of Payment Check Check Debit Card Check Transfer Check Check Credit Card Check Debit Card Check Transfer Credit Card Check Check Check Debit Card Debit Card -300 -202 2034.78 -300 -217.61 -175 -65.33 -43.59 -262 2034.78 -300 -109.64 -102.83 -233 Average Credit Card Purchase: 18 19 Total Remaining: 20 Payment Options: 21 22 23 24 25 26 -96.47 -60.08 -149.68 Check Credit Card Debit Card Transfer Criteria June Totals June 2017 AnnualExp HomeLoan CarLoan Stocks + Ready FO + 100%