Data Validation : Two drop down boxes

  • Hello Everyone,


    I have what should be a simple problem using drop down boxes. I am trying to create a quick sheet to calculate margins on various products. I have one drop down box were you pick the product. And then second drop down were you pick the value added services. Then I have another cell that should calculate the costs of the corresponding product and value-added service. Everything is working except for the cheapest value added service. Which is inserting 0 however is inserting the wrong value. It is inserting the value for another value added service. I am using the vlookup function to reference the drop down boxes. I have the table sort in ascending order. Thank you for your help.


    Regards,
    Jason