That's joining B2 and C2 together, so it will give you unique names. However, you can do this:
=INDIRECT(SUBSTITUTE(IF(C2="Test","",B2)&C2," ",""))
so that the named range Test will not be unique for the first choice code. You can use Test1, Test2 etc. for those that are unique.
Hope this helps.
Pete
Bookmarks