$1\mathrm{.}2$ Calculate "Rate

Charged" $($cell $($F$4))$ using the VLOOKUP function.

a$.$ The lookup$\_$value is the "Credit Score" $($cell C$4).$

b$.$ Table$\_$array refers to the "Car Loan Interest Rates" table $($range $(15$:K$12).$

The col$\_$index$\_$num is $3($the third column of thaseference table$).$

Finally, $[$range$\_$lookup$]$ is "TRUE" $($an approximate match is OK$).$

Copy your formula down complete the "Rate Charged" column. Be careful to use correct relative and absolute cell references.