Having trouble making a third dependent list with illegal characters

jordancvaughn

New member
Joined
Jul 31, 2013
Messages
1
Reaction score
0
Points
0
Age
32
Location
Camp Pendleton, CA
Greetings All,

I have been struggling for a few days trying to figure out how to get my third dependent list within my workbook to work with illegal characters using data validation. I have been trying to use a combination of the INDIRECT and VLOOKUP functions and have had no luck in resolving this. I've done plenty of research but have been unable to find exactly what I needed and was hoping someone here might be able to share their knowledge. I have attached the spreadsheet so feel free to have a look. The dependent lists fall in columns D, E, and F and is pulling the data from the third work sheet from named range values.

Is there an easier way to go about doing this or am I just failing at understanding functions within excel?

View attachment MITSC West CSC Cheat Sheet - Copy.xlsx

R/S,
Sgt Vaughn, Jordan C.
MITSC West Training Manager
 
Last edited:
Top