Drop down lists dependent on each other - is it possible?

I have a large worksheet with four columns (A, B, C, D) with the titles: Item #, MFG, Model, Qty. There are about a 1000 items in total, which means each of these columns has a 1000 cells each. My goal is to create a second worksheet which is blank but has the same titles. I want a drop down list for each category which are dependent on each other, though only the first three columns will be dependent on each other. For example, the first row says this: Item # (Column A) = 12 (Row 1) ; MFG (Column B) = 43 ; Model (Column C) = Air Duster.

If I choose Item # 12, then I automatically want the MFG - 43 and the Model - Air Duster to show up in their respective columns (kind of like a conditional formatting type situation). Subsequently, if I choose MFG - 43 in Column B, then I automatically want Item # 12 and Model - Air Duster to show up in that same row under their assigned columns.

Is this possible? This is a large spreadsheet with about 1000 items per column. How long would something like this take? And, if what I am looking to accomplish isn't possible, does anyone have any other solutions which may give me similar results? Thanks.

yes, check this:

http://www.excel-easy.com/examples/d...own-lists.html

http://www.contextures.com/xlDataVal02.html

Thanks. I have a general understanding how to make dependent drop down lists, but I want a conditional formatting type situation where I choose one choice, and the rest fills itself in. Is there any way to make List B dependent on List A, and List A dependent on List B? Meaning, that I can choose either list to make my first choice and the rest of the answers follow? Thanks.

I am attaching a "dummy" workbook file. I have everything set up how I had it when I posted this question.

Which list has no dependencies? And which entry needs to be a higher count than one? I am quite confused by your answer, do you mind elaborating? Thanks.

I am trying to do the same thing, but having some issues with my second column of data validation. Column E has my first set of data validation, which is working correctly. Column E does have some spaces and special characters (/) in some of the values though, so I am using the following for Source in column F: "=INDIRECT(VLOOKUP(E1,Lists!C2:D15,2,FALSE))". I have double checked, and the VLOOKUP seems to work correctly when just pasted into a cell to test. I've verified that "Lists!C2:D15", "2", and "FALSE" are correct (the list is not alphabetical), but I'm wondering if "E1" is correct, as I have a title row at the top, so the data itself is actually starting in E2 and F2.

Currently, depending on if I set it to E1 or E2, the second column of data validation will either not work at all, or it will find the result from a line or two below it.

I had read through a couple of the links above, but I guess my post is a bit unrelated to the specific issue. My apologies, I will create a new post.

The updated file you posted looks great. How do I get Row 3 to do the same thing as Row 2?