Hi,
Im not sure what I need for the attached spreadsheet but here is the scenario, Basically what I need is a calculator as show on sheet "Calculator" - I need the user to be able to use the dropdown boxes to select a model, engine & service required and the cells labeled below will become populated with the data as populated on the other sheet, i.e Cost is generated from the model/ engine row as selected and the fps is selected from the fps sheet along with pollen filter, brake pads etc., but I just cant get my head around what I need? Do I need a to use the lookup feature/ filtering or code? Any help would be most appreciated.
Bookmarks