Hi all
I'm having an issue when using dynamic dropdowns.
I recently had my workbook working as intended, with the dropdowns referencing lists on a different, hidden workbook. The list being referenced was "investment sector" and this would populate the list of sectors I wished to use. There was then a dependent dropdown (cell B108) which would use this function =INDIRECT(SUBSTITUTE(C108," ","")) to return another list of fund names within that sector (with C108 being the cell with the sector name in).
I recently decided not to use an additional workbook to reference, and use queries so that all the referencing happened from within my workbook itself.
The workbook I use needs to be copied over to a new workbook and historically this has left the functions intact. I have encountered an issue now though: one of my sectors will not produce the dependent dropdown for fund name in B108 however the rest remain working.
I can see no issues with the formula which provides these fund names, they're in an array as they should be, there are no superfluous spaces where there shouldn't be so I am at a loss.
Does anyone know of any other things to check why this won't be working? I'm very confused as the rest functions as it should!
Thanks in advance
Bookmarks