$=$VLOOKUP$($$A$$6$:$A$$32,$ RentalRates, $2,$ FALSE$)$In cell G$6,$ use the appropriate lookup and reference function to retrieve the rental rate from the named range RentalRates. The function should look for an exact matching value from column A in the data.

Copy the formula through cell G$32.$