Create pull down (list) based on specific information in previous cell

Hi All,

I would like to create a pull down menu (list) based on specific criteria in a previous cell (if that makes sense).

Example: If A1=2 then I want to pull data from Sheet 2 A1:A4 to create a pull down (list) of specific choices only geared towards that number. If A1=3 then it pulls from a different column creating a completely different pull down (list) result.

Does that make sense to anyone?

Thanks in advance for any help.

Hi,

Take a look at this http://www.contextures.com/xlDataVal02.html

Thank you for your responses...

I was trying to work through both of the examples that were provided but this seems to be over my head at this point.

Basically what I am trying to do (and its wrong per excel) is use an indirect command to look up several different lists.

Using Data Validation (list) here is an Example =IF(J7=1,Range_1,INDIRECT(J7))

BUT I was trying to do this in data validation

=IF(J7=1,Range_1,INDIRECT(J7),IF(J7=2,Range_2,INDIRECT(J7)))

Obviously this doesn't work as it wants to read as a formula now. So what am I doing wrong?

J7 is a result from an equation so it will change numbers 1-5 and I want the next cell over to reference a range list based on those results in J7.