Dropdown list with multiple values?

Question

excel

There are two columns in one name in another value, how to make a drop-down list to select the name, but the value was substituted, or connected somehow?

Answer 1

there is an example here