INDIRECT and drop down menus

Originally Posted by stojko89

I don't understand your 2 option

Did you try them ? I thought the instructions were fairly straight forward myself (delimiters aside).

Obviously it is up to you in terms of how you go about resolving the issue but the prior suggestions do as requested.

For the sake of confusion I've attached your original sample file with both the Evaluate and Dynamic Source suggestions in place
(the 2nd option is demonstrated in Column J so you can see both approaches would return identical result)

Note: the use of XLM call in the first option requires .xlsm file extension in XL2007+