jordancvaughn
New member
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
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: