Welcome to the Board.
You could run MATCH function tests on each named range and use the index position in the list of the choice made as your name.
If for the sake of example we assume A1 to A6 contain your various lists then you could perhaps use something along the lines of:
=TEXT(MATCH(A1,namedrange1,0),"000")&"-"&TEXT(MATCH(A2,namedrange2,0),"000")&"-"&TEXT(MATCH(A3,namedrange3,0),"000")&"-"&TEXT(MATCH(A4,namedrange4,0),"000")&"-"&TEXT(MATCH(A5,namedrange5,0),"000")&"-"&TEXT(MATCH(A6,namedrange6,0),"000")
Bookmarks