I am trying to create a worksheet where a value would be selected from a list to populate cell A1. Then, based on what was selected for A1, I want to show a particular list in the dropdown for A2. For example, if A1 = 100000 then the drop down in A2 would display 1234, 4567, 7890. if A1=100100 the drop down might only display 0000. The values for A1 and the corresponding valid values for A2 are in a separate worksheet in this workbook. Thanks for any help you might be able to give!!!