Dependant drop down list and database value

Hi everyone,

New on this forum, and I must say there's some good info on this. However, one thing I haven't been able to find is the thing I need the most.

My boss wants me to do all our invoices on excel. We sell structural plates, and they are of sizes ranging from 1 inch to 12 inches wide, and from 2 inches to 48 inches wide. and of three different gauges (20, 18 and 16). Unfortunately not all sizes are available in all three gauges. and not all lengths are available for every width. and of course their is a quantity per box value as well.

I was hoping that you guys can help me with this. Here is how i would like to have it work.

Cell A1 decides the gauge.
Cell A2 decides the width
Cell A3 decides the Length
Cell A4 displays the correct Quantity per box.

So basically, as far as I can envision this, A1 is independent, A2 depends on A1, A3 depends on A2, according to the values in A1, A2 and A3, It gives the quantity of Box.



Hope you guys can help me out on this one, I will really appreciate it.

Hi and welcome to the board,
this is a much asked question which often is solved by this link