Issue with dependent Data Validation

Hi,

There are 2 types of query under query type that is Benefits & HR Operation , when I select any one, under sub query type only the queries should display that belongs to query type. I have done this. But when I select query type as “benefits” and sub query type as anything as in the table then in last column under “call activity” all call activity should display (activities like – inbound, outbound, Outbound or VM call back, VM Retrieval, Forwarded to CAST, Escalated to ABC, Escalated to XYZ)

Attached the sample sheet for your reference. if possible do it with this sheet and post it.

Thanks!

how is column c dependent on sub query type?

I've added a second named range for each group that covers the column E choices, and edited the Data Validation for the Call/Activity section to use the second range.

Hello Anwitha,

See the attached. Moved the validation entries in to a new sheet. You can Add/Delete Query/SubQuery/CallActivities.

See the attached.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.