Validation in Excel

If I create a validation drop down list for a cell and then use that list to enter a value in the cell, can I create a formula in another cell to reference a valuefor the inserted validation list info?
Example:
My list for cell B16 contains 4 partnumbers:
EB1
EB2
EB3
EB4

EAch of these part numbers has a specific weight
EB1 100w
EB2 75w
EB3 60w
EB4 50w

When I select EB1 from the list for B16, I would like the associated weight (100w) to show up in cell D16.