![]() |
Dependant drop down list with more than two words in the options
I have looked at Debra Dalgleish's site but can't find the answer for this one.
I have a named list with only four option but each of the four entries is between 8 and 10 words long. I can't reduce them to one or two word options. The second, dependant list has similarly long options. How do I get the second list to refeerence the first but using these multi worded options? Can I modify the =INDIRECT(SUBSTITUTE(A1," ","")) function? -- Traa Dy Liooar Jock |
All times are GMT +1. The time now is 09:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com