[EXCEL] How do I tell excel to input some specific data when an item is chosen from a list

Hey everyone.

I have never done any coding whatsoever, but I've been reading for a while, trying to figure out what everything means and does, and I'm quite lost.

​

My plan is to have 1 tab with a bunch of building materials, with the corresponding material density in the next column. Then in tab 2 I want to make a dropdown menu, to pick which material I am using, and then have Excel input the correct material density in the next column.

​

Maybe I'm making it more complicated than it really has to be, but would love if someone can point me in the right direction, so I can learn how to do this sort of thing.