Multiple sublists using Data Validation

[Lilfiger19]

Hi All!

I am so hoping someone can help me. Is there a way that I can set up more than 1 sublists in excel? Below is the criteria and conditions. I was able to create the Primary List and then the first sub-list but that is it.


Primary List:

Business Unit
1. Majors
2. SBS

Sub Lists 1:
Case Type/Request (All Case Types should link to the primary lists for all business units)

Sub List 2:

Depending on the case selection in sub list 1, this should show the Queue Name and/or Email Address that the case should be routed too.

Below is a screen print to show the setup of the excel file.

Column A is the Business Units
Row 1 is the Case Type/Request
Column B/Row 2 and on are the actual queue names and/or email addresses.

Business Unit	Manual Billing File(s) uploads	San Dimas Billing Inquiries
Majors & SBS	SERVICEMB@Test.COM	#ACCT-San Dimas
CompHR	N/A	N/A

<TBODY>
</TBODY>

 

[Lilfiger19]

I'm keeping my fingers crossed that this will be enough info for you to help me.

This column is named "BU" for the Range</SPAN>	This column is named "Request" for the Range</SPAN>	Range = Small Business</SPAN>	Range = Mid Market</SPAN>	Range = Premiums</SPAN>
Small Business</SPAN>	Request</SPAN>	Small Business</SPAN>	Mid-Market</SPAN>	Premiums</SPAN>
Mid-Market</SPAN>	Billing</SPAN>	SERVICEMB </SPAN>	N/A</SPAN>	FinanceSupport</SPAN>
Premiums</SPAN>	Client Info Update</SPAN>	Client#1</SPAN>	N/A</SPAN>	N/A</SPAN>
	Annual Report Billing</SPAN>	W2Queue#1</SPAN>	N/A</SPAN>	N/A</SPAN>
	Name Changes</SPAN>	Client#1</SPAN>	N/A</SPAN>	N/A</SPAN>
	Contact Updates</SPAN>	Client#1</SPAN>	N/A</SPAN>	N/A</SPAN>
	Invoice Grouping</SPAN>	Invoicing</SPAN>	N/A</SPAN>	N/A</SPAN>
This table is named "Lookup"</SPAN>
Business Units</SPAN>
Small Business</SPAN>	Requests</SPAN>	Majors</SPAN>	Queues</SPAN>
Mid-Market</SPAN>	Requests</SPAN>	CompHR</SPAN>	Queues</SPAN>
Premiums</SPAN>	Requests</SPAN>	TLM_NAS</SPAN>	Queues</SPAN>
COS</SPAN>	W2/Qtr Rate Exceptions</SPAN>	COS.Billing@adp.com</SPAN>
This is the drop down list that houses the Business Unit</SPAN>	This is the list that shows the case types by BU</SPAN>	****This is where I am having the issue, I can't get it to select only one item that should tied select based off of BU Then Request</SPAN>
=BU by data validation</SPAN>	=INDIRECT(VLOOKUP($A$2,Lookup,2,FALSE))</SPAN>	=INDIRECT(VLOOKUP($A$2,Lookup,3,FALSE))</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL span=2></COLGROUP>