auto-transfer data

Would somebody be able to help me on the following problem ? I've seen some companies employing external database generators to do this, but I believe excel may have something built in.

PROBLEM :
There’s one “master table”. Two columns in master table are titled “Name-1” and “Name-2”, and all columns in front of it carry “Properties” corresponding to these names.
In a “second” table, when we choose/type the Name-1 and Name-2, corresponding properties should automatically be picked up from the master table. Is that possible ?

The two tables are attached. Thanks.