IF THEN with Data Validation List

[The Bat]

I have a cell with a drop down list of three options. I have data on different pages of this sheet that I want to be able to pull into the main sheet based on which option is selected form my data validation sheet. So if the user selects option "B" from the data validation list, cell range A13:A31 will call in the contense of PAGE2! A1:A20; however, if they select a different option from the list it will call in a different set of data from a different page. Is this possable?

[MarvinP]

Hi The Bat and welcome to the forum,

The topic you need to read is "Cascading Validation" or "Dependent Validation". See if that helps you find what you need.

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