Hi and welcome to the forum

For the drop-down, take a look at Data Validation - use LIST and make the necessary part of the table your range

for the other cells, take a look at using the VLOOKUP() function