Data Validation: Drop down Boxes and V Lookup

  • Hello Everyone,


    I have seven products which all have a different costs. Of those seven products I have four value-added functions that can be performed. Depending on the seven products each value-added activity has a certain cost. What I would like to do is create a worksheet that allows me to drop down the correct product and then pick the correct value-added activity and the cost that corresponds.


    I have attached a file that may explain what I am looking for better. Thank you for your help.


    Cheers,
    Jason

  • I think the attached will do what you want. It picks the VLOOKUP column based on the Product digit. If your real sheet uses actual names, you may need to create an intermediate cell that VLOOKUPs the column number based on the product name (or lengthen the formula to incorporate this LOOKUP in the column argument spot.)

  • Thank you. That is what I am looking for however my real sheet uses product names. Would you be able to attach another file that shows how to do your other two suggestions?

  • Hi. I'd be happy to provide an example as you ask, but it will take me a while ot get to it. Just got in to work and it is a very full day. Hopefully someone will jump in and beat me to it, otherwise I'll be back in about 8 hours (or maybe 4 if I can get some time over lunch).


    P.S. You may want to remove the "Solved" temporarily as this might reduce the number of folks who look at the thread.

  • Got a few few minutes. Here is one implementation. The Value-Added column lookup numbers could just as easily have been added to D2:D8 and then used B2:D8, column 3 for the second lookup in C15. Having a separate table allows you to hide the table on anothe sheet if you prefer.


    Hope this helps.


    Tom