I am trying to link a dynamic list to the value of a cell (D2) immediately to the left (reference cell). The reference cell (C2) is itself is populated by the user (it is a list of country codes). In other words depending on the country code selected in C2 the user will then be confronted (in D2) with a dropdown list dependent on what country code they select. E.g. for the country code UK I have: Ambleside, London,Manchester set up as a dynamic list (which will expand as and when I add to it). In D2 I set the cell up as a list with "=INDIRECT(C2)" (without quotations) but I have found that it does not recognise this (i.e. no dropdown list appears.
I have found that if I use a non-dynamic list this works... so assume it is something to do with trying to use a dynamic list.
Can anyone advise whether there is a work around or if I am doing something wrong?
(Ps. I was on here before but lost my login details).