$0.$ Name the cell b$4$ in this sheet as $"$id$",$ the array in "Exit Ticket LC loan Data!A$1$:AB$1999"$ as "loans", and the array in "Exit Ticket LC loan Data!A$1$:AB$1"$ as "headers", use these as references throughout the exit ticket swiftsuperbowl Magic code INSTRUCTIONS Fill out the shaded cells $($A$4,$ A$8,$ A$13,$ etc...$)$ with formulas to return the values requested $1.$ Write a MATCH$()$ function that returns the row of $"$id$"$ from A$1$:A$1999$ You MUST leave loanID $1071570$ in B$4,$ and "sub$\_$grade" in b$241071570$ Loan id Otherwise you'll receive no credit $4031063899$ Example ID and correct answer $1$b$.$ Change the format of A$8$ to Wrap text. Write a set of functions that displays $1)$ the text "Loan id $"($notice the trailing space$),2)$ the id in b$4,3)$ a new line character, $4)$ the text "Emp$\_$title $",5)$the emp$\_$title value that corresponds to the loan identified by the loan id in b$4.$ Use Vlookup$()$ to return the value of emp$\_$title. See the example answer in a$9$ for loanid $1063899.$ Don't forget to change the cell height $($autofit$)$ so you can see the line break "Loan id $1063899$ Emp$\_$title Rudy's Barbershop" Example ID and correct answer $1$c Write an INDEX$()$ function that uses the row in A$4$ to return the value of the sub$\_$grade from column I of the loans array #NAME? C$2$ Example correct answer for $10638991$d$.$ Write a function to find the installment amount $($column G$)$ of the loan identified in b$4.$ Use an Hlookup$()$ function and b$17$ as the Lookup$\_$value and a$4$ as the field that defines the correct row. Hint $-$ you're going to be using text in B$17$ as the lookup$\_$value in your Hlookup so double check your spelling The field you are looking up in "loans" $223\mathrm{.}01$ Example correct answer for $10638992.$ Use a vlookup function in cell a$21$ to return the value of the title $($column U$)$ for a loan id given in b$4.$ The light Example correct answer for $10638993.$ Pull it all together. In a$24,$ create a match function nested within a vlookup function to return the field defined in b$24$ for the loan id in b$4.$ Before your final submission, put "int$\_$rate" in b$24$ sub$\_$grade The field you are looking up in "loans"