Use Vlookup for that.

In Vlookup you can reference to the cell with the dropdown.