Dependent Data Validation - Indirect Function

Please see attached. I cannot get my indirect function to work in Cell K2 based on cell J2

Data for the Validation is in cells W1 to AC14

I want to do data validation in Column K based on Column J, but cannot get the indirect function to work to past into the data validation tool

I have named all my ranges, but cannot figure it out

Can you please assist?

AM Call Log.xlsm

I'm sorry but I just have no idea what you're asking.

I cannot get my indirect function to work in Cell K2 based on cell J2

There is no indirect function in cell K2. The function in K2 is

Formula:

=SUBSTITUTE([@[Contact Purpose]]," ","_")

Data for the Validation is in cells W1 to AC14

I want to do data validation in Column K

I could not find any data validation in column K or anywhere else.

So all I understand is that you want to do data validation in column K and can't get it to work. But you have given no idea at all of what you are trying to validate, how you are trying to use INDIRECT, or anything else. Please try to explain your question again.

Sorry - I am trying to validate Column K based on what is selected in Column J

For example - when i select 'ALF Activity - In-Service' in Column J - I only want the options in K to be the following:

Consultant Visit
Education
Resident Meeting
Omniview Training


ALF Activity - In-Service (Column J)
Consultant Visit (Column K)
Education (K)
Resident Meeting (K)
Omniview Training (K)

ALF Activity - New Customer
Marketing
On-Boarding
Increase Participation

ALF Activity - Relationship Development
Executive Review
Survey
Increase Participation
On-Boarding

ALF Activity - Technology
Omniview Promotion
MyOmniview
Emar

ALF Ops - Equipment
Fax Machine
Carts
Dispensing System

ALF Ops - Issue Resolution
STAT
Billing
Delivery
Returns
Med Availability

ALF Ops - Quality Assurance
MAR to Cart
Medical Records

SNF Activity - In-Service
Brand2Generic
Consultant Visit
Education
IV Program
Omniview Training

SNF Activity - New Customer
Marketing
On-Boarding

SNF Activity - Relationship Development
Census
Executive Review
Survey

SNF Activity - Technology
Omniview Promotion
MyOmniview
Emar

SNF Ops - Equipment
Fax Machine
Carts
Dispensing System

SNF Ops - Issue Resolution
STAT
Billing
Delivery
Cost Containment
Returns
Med Availability

SNF Ops - Quality Assurance
MAR to Cart
Medical Records
Physician Order Sheets