ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Dependant drop down list with more than two words in the options (https://www.excelbanter.com/excel-worksheet-functions/228704-dependant-drop-down-list-more-than-two-words-options.html)

Jock

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