VLOOKUP EXAMPLE The table to the right below is the current interest rate that a bank charges for loans of varying amounts Aloan for, say $4800 would be charged 4.75% interest. Loans exceeding $20,000 would be charged 2.5% interest. Please enter the VLOOKUP formula in Cell C8 to find the rate that would be charged for an $18541 loan. Then copy Cell C8 down the yellow cells to calculate the rates that would be charged for the other loan amounts. Interest Rate Loan $ 18,541.00 $ 4,884.00 $ 25,903.00 $ 8,164.00 $ 27,499.00 $ 350.00 $ 13,064.00 $ 9,676.00 $ 11,404.00 $ 13,341.00 $ 4,181.00 $ 6,609.00 $ 13,336.00 $ 6,630.00 "Interest Rate Key" Loan Bank Amount Interest Rate $ 100.00 5.00% $ 500.00 4.75% $ 1,000.00 4.50% $ 2,000.00 4.00% $ 5,000.00 3.50% $ 10,000.00 3.25% $ 15,000.00 3.00% $ 20,000.00 2.50%