1 B15 A X fx 2 3 B C D 4 First Name: Mary 5 Last Name: Bell 6 Address: 123 First Street 7

m G = 600 = "Approved" 3. Create a VLOOKUP function in cell B14 that uses the Credit Score in cell B9 to generate a rate based on the array in cells 14:10

1 B15 A X fx 2 3 B C D 4 First Name: Mary 5 Last Name: Bell 6 Address: 123 First Street 7 City, State Zip: Philadelphia, PA 19104 8 Annual Income: $ 85,000 9 Credit Score: 720 10 Requested Amount: $ 25,000 11 # of Payments 120 12 13 Decision: 14 Rate: 15 Payment: 16 17 E F Application For Personal Loan G H Credit Score Current Rate 500 6.50% 550 6.25% 600 6.00% 650 5.25% 700 4.50% 750 3.75% 800 3.25% K L M N P Q R S T