Dependent Dropdown List

Microsoft Microsoft excel 2007 (pc)
March 18, 2010 at 23:46:51
Specs: Windows Vista

I'd like some help with a problem. I've a data
set that looks like this:

Col 1 Col 2 Col 3 Col 4
A 2 100 X
A 3 200 X
A 4 300 Y
A 5 400 Z
B 3 300 X
B 4 400 Y
B 5 400 Y
B 6 500 Z

I need four data entry cells for Col1 - Col4 with
in-cell dropdown list. If a value in Col1 is
selected, only the possible values should
appear for Col2. When Col2 is selected, the
possible values from Col3 should appear and
so on. For example: A, 3, 200, Z selection
should not be possible.

Thanks for all the help in advance!

See More: Dependent Dropdown List

March 19, 2010 at 05:40:23

The trick here is to use the INDIRECT function and Named Ranges.

Instead of detailing all of the steps in a response, I'll suggest that you review the instructions found here:

You can also Google "Dependent Dropdown List" for a lot more hits.

If you have any trouble setting these up, let us know.

Report •
Related Solutions

Ask Question