Pop-up (drop down) menu populating information specific to your selection

I have a list of products in a drop down list, or pop-up menu, and when I select it, I want it to populate all the parts that need to be ordered for that product. I currently have 2 tables, the first being the table for the drop down and populated information, the second being the data sheet. An example of my data sheet:

what I would like is to use my 1st table to select "A" from the pop-up menu and next to it will populate the information (part number, description, and qty) in the cells next to the drop down. I'm very new to numbers and was able to get this to work on excel, I'm just hoping it will be possible. Thank you for any help you can provide!