Results 1 to 1 of 1

Thread: Having trouble making a third dependent list with illegal characters

  1. #1
    Neophyte jordancvaughn's Avatar
    Join Date
    Jul 2013
    Location
    Camp Pendleton, CA
    Posts
    1
    Articles
    0

    Having trouble making a third dependent list with illegal characters



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?

    MITSC West CSC Cheat Sheet - Copy.xlsx

    R/S,
    Sgt Vaughn, Jordan C.
    MITSC West Training Manager
    Last edited by jordancvaughn; 2013-07-31 at 08:30 PM. Reason: Forgot Attachment

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •