Data Validation Lists

[SteveBC]

If I have a drop down list with 5 options in it (say cell A1) and I wish to create a further dropdown list in cell A2 looking at lists in cells B2 to B20, C2 to C20, etc. with a header at the top of each list based on which option was selected in A1, what formula/function would I use in A2 please.

 

[Scott T]

This explains how to create depended data validation.

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