Hey guys.



I got a dropdownlist in my Workbook and I know somehow it's possible to make it work ranged names with spaces, But I just can't make it work!

If you look at sheet1 I marked it as yellow, (GlasFärgat/GlasOfärgat) But I would want it to be possible to show "Glas (Färgat)" & "Glas (Ofärgat)"

That cell B10:B16 is dependent on cell D10 : D16. (D10 : D16 has a conditional formatting with Indirect function). But is it possible to sort it out to show my desired names or do I have to stick with the present? :S

Attached Files

Dropdownlist.xls (231.0 KB, 14 views)