Provided the named ranges CodeR110, CodeR210, etc., match the entries in the initial drop down list, it's just:

Formula: copy to clipboard
=INDIRECT($H7)



Regards, TMS