Use VLOOKUP to calculate the registration fee for each vehicle.

Enter a formula in cell C$12$ to look up the registration fee for the first vehicle. Use the vehicle type in cell C$4$ as the Lookup$\_$value argument. Use the VehicleData named range as the Table$\_$array argument. The registration fees are located in column $2$ of the data table. Require an exact match.

Copy the formula to the appropriate cells for the other vehicles.