I have a sheet with 3 drop down boxes on it. I want to be able to select a choice in drop down 1 and then have drop down 2 populated with choices based off of what the user selects in drop down 1, then after the user makes a choice in drop down 2, a number between 15 and 30 in drop down 3 is selected and a cell is populated with info based off of all three drop downs. Sound confusing? Here is an example...We will say drop down 1 has the choices of blank, HNL, OGG and ITO. If the user picks HNL then drop down 2 gives the choices 4L, 4R, 8L. If OGG is picked then drop down 2 lists 5, 23. So we decide to pick HNL, 4L and then 15. When this is done I want the combination of all three choices to wind up choosing a paticular value that I will have stored in a table of cells. So maybe HNL, 4L and 15 = 522 and HNL, 4L and 16 = 519 etc.

So far I have drop down 1 working with my choices and then it outputs to cell E10. I'm thinking if I can get drop down 2 to read E10 and then based off of whether it says 1, 2, 3 or 4 it chooses a different input range of say nothing (blank), G3:J3, G4:H4 or G5:H5 to use as its choices. Any idea's?

Once that's worked out the simplest way I can think of to setup drop down 3 is read the choice in drop down 2 by outputing again to a different cell(probably a different cell for each selection in drop down 1), and combine it with the number in drop down 3 and then retrieve data at a hard coded table.

So can anyone give me some advice on how to tackle this? Thanks in advance!

D