Solved Excel 2010 Drop-Down List

Microsoft Excel 2003 (full)
February 6, 2012 at 09:30:37
Specs: Windows XP, 1.0Gb
I have tried to write two drop-down lists in separate columns where the choice from List 2 will be dependent on the choice from List 1. I am able to get List 1 to work correctly but not List 2 as I can not figure out the way to link the two lists.

List 1 contains "CL", "FI" and "HN".
If "CL" is picked, I want the dependent list to show "18.13" and "27.20".
If "FI" is picked, I want the dependent list to show "20.68" and "31.02"
If "HN" is picked. I want the dependent list to show "20.33" and "30.50".

Thank you.
Brian W


See More: Excel 2010 Drop-Down List

Report •


#1
February 6, 2012 at 10:59:34
✔ Best Answer

Report •
Related Solutions


Ask Question