Cell dependent on another cell's drop down list

I would like cell D23 to equal the corresponding cell of D4. I'm not sure how to do this. The example I would use is if cell D4 equals 22 (From the "Diameter" table) from the drop down list, I would like cell D23 to automatically equal 10 from the "Bolts" table.