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