Data Validation List based on a Lookup Value

Question

I am trying to generate a Validation list in Excel 2016 based on a value entered in another cell, ex.

I Have a 2 column worksheet: Column A represents categories, Column B represents sub-categories.

Cell A1=Luncheon

I want Cell B1 to present  a drop down list based on the value in A1:

Another worksheet contains a 2 column table with all possible values for column A:

Category       Sub-category

Luncheon     January

Luncheon     February

Luncheon     March

BusTrip         New York

BusTrip         Washington

In this example, the validation list would display "January", "February", "March".  The Data Validation Function doesn't seem to support this capability.

Answer 1

If I am interpreting your question correctly then you want cascading (or dependent) dropdown lists. The following links to Contextures by Debra Dalgleish might help: 

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

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