Dynamic VLOOKUP and Summation Calculation

Dynamic VLOOKUP and Summation Calculation

I am trying to do the equivalent of a series of excel VLOOKUPs. I have uploaded a dataset where column A is "Car_Model", column B is "Car_Cost", column C is "Insurance_Cost".

I'd like to only use "Car_Model" as an input (via a drop down) and then show Car_Cost, Insurance_Cost and Total_Cost (a sum of the two) as dynamic outputs.

By visiting a few similar posts on the topic, I understand that I need to use a "fetch" here but I'm unclear on how to implement it.

Thanks a lot!
Sam