the range lookup arqument to ensure an exact match, In cell F5, insert a lookup
ID: 3736882 • Letter: T
Question
the range lookup arqument to ensure an exact match, In cell F5, insert a lookup function that uses the credit rating in cell C7 to determine the minimum down payment based on the table array A15:C18. Indude the range_Jlookup 9 argument to ensure an exact match. Multiply the function results by the negotiated cost of the vehicle With the sale of any car, the sales tax needs to be computed. You could take a calculator and in han!..A intn Evral hit vnu know that does not make sense because you wish to re-Explanation / Answer
The VLOOKUP function in cell F5 that uses the credit rating in cell C7 to determine the minimum down payment based on table array A15:C18 is :
Assuming, column 2 of the table array A15:C18 contains the minimum down payment
F5 =VLOOKUP(C7,A15:C18,2,FALSE) * negotiated_cost_of_vehicle
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.