rwg, no need to change the contents of the named range in this instance (given this after all UI preference) - given the two lists correlate in terms of order you can just match selection against the named range itself (as shown).

D.O